|
TRIMMEAN |
  
|
|
TRIMMEAN |
|
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)
See Also