# TRIMMEAN Function in Excel – Calculate truncated mean in Excel

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 %.