Excel functions / Statistics
HARMEAN function
The harmonic mean: the right average for rates such as speeds.
Syntax
=HARMEAN(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
When to use it
HARMEAN gives the harmonic mean: the count of values divided by the sum of their reciprocals. It is the right average for rates over the same distance or amount, such as speeds over equal legs of a trip.
Examples
Average speed out at 60 and back at 40
A B C 1 Speed 2 60 48 3 40 In C2:
=HARMEAN(A2:A3)→ 48Not 50: more of the trip's time was spent at the slower speed.
Common mistakes
- Zeros. A zero or negative value gives #NUM!.
HARMEAN 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: HARMEAN
- Danish: HARMIDDELVÆRDI
- Dutch: HARM.GEM
- Finnish: KESKIARVO.HARM
- French: MOYENNE.HARMONIQUE
- German: HARMITTEL
- Hungarian: HARM.KÖZÉP
- Italian: MEDIA.ARMONICA
- Norwegian: GJENNOMSNITT.HARMONISK
- Polish: ŚREDNIA.HARMONICZNA
- Portuguese (Brazil): MÉDIA.HARMÔNICA
- Portuguese (Portugal): MÉDIA.HARMÓNICA
- Russian: СРГАРМ
- Spanish: MEDIA.ARMO
- Swedish: HARMMEDEL
- Turkish: HARORT