ReferenceFunctionsStatistics Functions
TRIMMEAN
TRIMMEAN: Returns the mean after trimming a percentage of values from both tails.
Summary
TRIMMEAN sorts numeric data, removes an equal count from low and high ends, then averages the
remaining interior values.
Remarks
percentmust satisfy0 <= percent < 1.- The trimmed count per side is
floor(n * percent / 2). - Returns
#NUM!for invalid percent values or when no numeric values are available.
Examples
Trimmed mean from direct values
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3.5
Trimmed mean from a range
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
16.5
Related functions
Runtime metadata
Category
Statistics
Signature
TRIMMEAN(arg1, arg2, ... argN: Number (Range))This function accepts a repeating argument pattern (min args: 2).
Arity
min 2, max 1
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PUREREDUCTIONNUMERIC_ONLY
Source