Related Topics: | ||
Description: Returns the cumulative or instantaneous MTBF for a given time.
Syntax: MTBF(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 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).
The Time value must be greater than 0.
Cumulative is shown in the function as a numerical value that indicates the selected calculation; for cumulative failure MTBF, Type = 1; for instantaneous MTBF, Type = 0.
Example:
MTBF (“Folio1!Data 1”,1000,1,0.8) = 140.12
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.