This function returns the mean of a subset of data excluding the top and bottom data.
TRIMMEAN(array,percent)
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) |
Accepts numeric data for all arguments. Returns numeric data.
TRIMMEAN(A1:A17,0.25)