How to Use TRIMMEAN in Google Sheets in 2020?

TRIMMEANCalculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

Sample Usage




TRIMMEAN(data, exclude_proportion)

data – Array or range containing the dataset to consider.

exclude_proportion – The proportion of the dataset 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 dataset.

GEOMEAN: Calculates the geometric mean of a dataset.

AVERAGEA: Returns the numerical average value in a dataset.

AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.