PREL

For reliability growth data analysis only.

Description: Returns the Projected Reliability at the termination time. This applies to data using the Crow Extended and Crow Extended - Continuous Evaluation models.

Syntax: PREL(Data_Src, [Time], [Conf_Level])

  • Data_Src is the source data sheet from which the value is taken.

  • Time is the time at which the value is calculated.

  • Conf_Level is the percentage (entered as a decimal value) for the confidence bounds. It is an optional value and, if specified, must be greater than 0 and less than 1.

Remarks:

  • The Data_Src can be one of the following values:

    • A default data source selected from the Data Source Index drop-down list.

    • A data sheet name (e.g., "Weibull!Folio1!Data1").

    • A variable name defined in the Defined Names window (e.g., datasource).

  • The Time value must be greater than 0.

Example:

  • PREL(“RGA!Folio1!Data1”,100,0.9)