TRIMMEAN
Returns the mean of the interior of a data set.
StatisticalStatistics & Analysis
What it does
Calculates mean excluding top and bottom percentage of data points.
Syntax
TRIMMEAN(array, percent)
Arguments
array(range) — Data.percent(number) — Fraction to trim (e.g. 0.2 removes top 10% and bottom 10%).
Examples
Trimmed Mean
Mean excluding outliers (20%).
FORMULA
=TRIMMEAN(A1:A5, 0.4)
RESULT
30
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
| 6 | 1000 |