# 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: