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:

 

A
B
1
Data
Data points Trim Percentage
2
4
0.2
3
5
0.3
4
6
0.4
5
7
0.4
6
2
0.3
7
3
0.2
8
4
0.1
9
5
0.3
10
1
0.2
11
2
0.4
12
3
0.1
13
14
Mean of the subset of the data set contained in A2:A12, with 20 percent excluded from calculation:
3.777777778

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close