Related Topics: | ||
Description: Returns the value of the failure rate at the specified time.
Syntax: FAILURERATE(Data_Src, Time, [Confidence Level])
Data_Src is the source data sheet from which the value is taken.
Time is the time at which the failure rate is calculated.
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).
The Time value must be greater than 0.
Confidence Level is an optional value and, if specified, must be greater than 0 and less than 1.
Example:
FAILURERATE("Folio1!Data 1", 5) = 4.938801301E-005
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.