TRIMMEAN
Returns the mean of the interior of a data set, excluding a percentage of data points from the top and bottom
Syntax
TRIMMEAN(array, percent)
Parameters
- array: Required. The array or range of values to trim and average
- percent: Required. The fractional number of data points to exclude from the calculation
Example
=TRIMMEAN(A1:A10, 0.2)