Related Topics: | ||
Description: Returns the cumulative or instantaneous failure intensity for a given time.
Syntax: FI (Data_Src, Time, Type, [Conf_Level])
Data_Src is the source data sheet from which the value is calculated.
Time is the time at which the value is calculated.
Type allows you to select whether to calculate the cumulative or instantaneous failure intensity.
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:
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).
The Time value must be greater than 0.
Type is shown in the function as a numerical value that indicates the selected calculation; for cumulative failure intensity, Type = 1; for instantaneous failure intensity, Type = 0.
Example:
FI (“Folio1!Data 1”,100,0,0.9) = 0.0117159326
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.