This function returns the mean of a subset of data excluding the top and bottom data.
Syntax
TRIMMEAN(array,percent)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| array | Array of values to trim and find the mean |
| percent | Fractional amount of data in array to trim (to exclude from calculation) |
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
TRIMMEAN(A1:A17,0.25)
Version Available
This function is available in product version 1.0 or later.
See Also
GEOMEAN | HARMEAN | Statistical Functions