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 to0
and less than1
.
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
|
C
|
|
---|---|---|---|
1
|
Data points Trim Percentage
|
||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
|||
11
|
|||
12
|
|||
13
|
|||
14
|