Calculates the mean of a data set excluding some proportion of data from the high and low ends of the data set.
Sample usage
TRIMMEAN(A2:A100,0.1)
TRIMMEAN({1,1,2,3,5,8,13,21,34,55},0.05)
Syntax
TRIMMEAN(data, exclude_proportion)
-
data
– The Array or range containing the data set to consider. -
exclude_proportion
– The proportion of the data set to exclude from the extremities of the set.exclude_proportion
must be greater than or equal to 0 and less than 1.
See also
HARMEAN
: Calculates the harmonic mean of a data set.
GEOMEAN
: Calculates the geometric mean of a data set.
AVERAGEA
: Returns the numerical average value in a data set.
AVERAGE
: The AVERAGE function returns the numerical average value in a dataset, ignoring text.