Excel functions / Statistics

GEOMEAN function

The geometric mean: the right average for growth rates.

Syntax

=GEOMEAN(number1, [number2], …)

Arguments

When to use it

GEOMEAN gives the geometric mean: the number that, multiplied by itself as many times as there are values, gives their product. It is the right average for growth factors and ratios, where AVERAGE overstates the result.

Examples

  1. The average yearly growth

    ABC
    1Growth factor
    21.109.7%
    31.50
    40.80

    In C2: =GEOMEAN(A2:A4)-1 → 9.7%

    AVERAGE would say 13.3%, which those three years did not deliver.

    Try this example

Common mistakes

GEOMEAN 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 GEOMEAN in the playground

Related functions