| SpreadJS Documentation > Formula Reference > Formula Functions > TRIMMEAN |
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)