Related Topics: | ||
Description: Returns the time corresponding to the specified MTBF.
Syntax: TIMEATMTBF(Data_Src, MTBF, Cumulative, [Conf_Level])
Data_Src is the source data sheet from which the value is calculated.
MTBF is the value of the MTBF at which the time is calculated.
Cumulative allows you to specify either the cumulative or instantaneous MTBF.
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).
Cumulative is shown in the function as a numerical value that indicates the MTBF calculation; for cumulative MTBF = 1; for instantaneous MTBF = 0.
Example:
TIMEATMTBF(“Folio1!Data 1”,234,0,0.9) = 2744.245089
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.