Definition

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

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 - 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: Returns the numerical average value in a dataset, ignoring text.

In order to use the TRIMMEAN formula, start with your edited Excellentable:

Then type in the TRIMMEAN formula in the area you would like to display the outcome:

By adding the values you would like to calculate the TRIMMEAN formula for, Excellentable will generate the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More