Excel functions / Statistics
GEOMEAN function
The geometric mean: the right average for growth rates.
Syntax
=GEOMEAN(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
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
The average yearly growth
A B C 1 Growth factor 2 1.10 9.7% 3 1.50 4 0.80 In C2:
=GEOMEAN(A2:A4)-1→ 9.7%AVERAGE would say 13.3%, which those three years did not deliver.
Common mistakes
- Negative values. GEOMEAN needs positive numbers. Write growth as factors (1.10 for +10%, 0.80 for -20%), not as percentages.
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.
- Czech: GEOMEAN
- Danish: GEOMIDDELVÆRDI
- Dutch: MEETK.GEM
- Finnish: KESKIARVO.GEOM
- French: MOYENNE.GEOMETRIQUE
- German: GEOMITTEL
- Hungarian: MÉRTANI.KÖZÉP
- Italian: MEDIA.GEOMETRICA
- Norwegian: GJENNOMSNITT.GEOMETRISK
- Polish: ŚREDNIA.GEOMETRYCZNA
- Portuguese (Brazil): MÉDIA.GEOMÉTRICA
- Portuguese (Portugal): MÉDIA.GEOMÉTRICA
- Russian: СРГЕОМ
- Spanish: MEDIA.GEOM
- Swedish: GEOMEDEL
- Turkish: GEOORT