TRIMMEAN

Returns the arithmetic mean value of the interior of the numeric data in a data set when outlying data is excluded.

Syntax:

TRIMMEAN(array, percent:number)

Returns the arithmetic mean value of the interior of the numeric data in the 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%).

Added in 1.36.