Related Topics: | ||
Description: Returns the value of the MTTF (Mean Time to Failure).
Syntax: AMEAN(Data_Src, [Confidence Level])
Data_Src is the source data sheet for which the mean value 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 via the Defined Names window (e.g., datasource).
Confidence Level is an optional value and, if specified, must be greater than 0 and less than 1.
Example:
AMEAN("Folio1!Data 1", 0.1) = 100.7358778
Note that this value will vary depending on the source data set.
© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.