Excel functions / Statistics

TRIMMEAN function

The average with a share of the highest and lowest values left out.

Syntax

=TRIMMEAN(array, percent)

Arguments

When to use it

TRIMMEAN averages the data after dropping a share of the highest and lowest values, so a few outliers do not pull the result. The share is split evenly between the top and the bottom.

Examples

  1. Response times without the extremes

    ABC
    1Response (min)
    234.75
    34
    44
    55
    66
    730

    In C2: =TRIMMEAN(A2:A7, 0.4) → 4.75

    40% of six values is 2.4, rounded down to 2: one from each end.

    Try this example

  2. The plain average for comparison

    ABC
    1Response (min)
    238.67
    34
    44
    55
    66
    730

    In C2: =TRIMMEAN(A2:A7, 0) → 8.67

    Try this example

Common mistakes

TRIMMEAN in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try TRIMMEAN in the playground

Related functions