Returns the arithmetic mean value of the interior of the numeric data in a data set when outlying data is excluded.
Syntax:
TRIMMEAN(data:array|range, percent:number)
Returns the arithmetic mean value of the interior of the numeric values in the data array (or range of cells) when the lower and upper percent range of values are excluded from the calculation.
percent should be in the range [0.0,0.5] (i.e. 0% to 50% inclusive).
Revisions:
This function was added in 2.00.