Skip to main content

TRIMMEAN

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.