Related Topics:

Spreadsheet Data Source Functions

Function Wizard Functions

Function Wizard

PARAMETER

Description: Returns a specified parameter value.

Syntax: PARAMETER(Data_Src, Param_index, [Subpop_index], [Confidence Level])

Data_Src is the source data sheet from which the information is taken.

Param_index is the index specifying the parameter to be returned. The parameter index corresponds to the order that the parameters appear in the calculated results in the Folio, as shown in the next table.

	Index 1	Index 2	Index 3	Index 4
Weibull	Beta	Eta	Gamma
Normal	Mean	Std
Lognormal	LogMean	LogStd
Exponential	Lambda	Gamma
G-Gamma	Mu	Sigma	Lambda
Gamma	Mu	K
Logistic	Mu	Sigma
Loglogistic	Mu	Sigma
Gumbel	Mu	Sigma
Weibull-Bayesian	Prior Distribution (see table below)	Parameter1 (see table below)	Parameter2 (see table below)	PstMed / PstMean

	Normal (0)	Lognormal (1)	Exponential (2)	Uniform (3)
Parameter1	Mean	LogMean	Lambda	Min Beta
Parameter2	Std	LogStd		Max Beta

Subpop_index is the index specifying the subpopulation to be used by the function. Use this if the specified data sheet was calculated with a mixed Weibull distribution or competing failure modes.

Confidence Level is the percentage (entered as a decimal value) for the 1-sided confidence bounds.

Remarks:

The Data_Src can be one of the following values:

If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in the Defined Names window (e.g., datasource).

Subpop_index is an optional value and, if specified, must be a positive integer value between 1 and 4.
Confidence Level is an optional value and, if specified, must be greater than 0 and less than 1.

Example:

PARAMETER("Folio1!Data 1", 1, 1, 2) = 2.35

Note that this value will vary depending on the source data set.

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.