TRIMMEAN function in Excel calculates the trimmed mean or truncated mean of a supplied set of values.
Note:
- The Trimmed Mean first discards some of the values at either end of the range, and then calculates the arithmetic mean of the remaining values.
- This prevents the mean being skewed because of extreme values.
Syntax of TRIMMEAN Function in Excel:
TRIMMEAN( array, percent )
array – An array of numeric values, for which you want to calculate the trimmed mean.
percent – The percentage of values to be discarded from the supplied array.
Example of TRIMMEAN Function in Excel:
Formula:
- Cells containing Text values, logical values, or no value are ignored by Excel TRIMMEAN Function.
- Truncated mean is calculated row wise in above example
- In the first example percentage of trimmed values is 20% e. 2 values, so 1 value will be discarded from each end of the range before calculating the mean of the remaining values
Similarly other truncated means are calculated and result will be
Result
Note:
#NUM! Error Occurs if:
- The supplied percent argument is < 0 or ≥1 which less than 0% and greater than 100 %.