Harmonic Mean in Excel
When to use harmonic mean?
This average is used when data values are expressed in relative units, e.g. speed unit (miles/ h) or salary per hour of work (USD / h).
The use of the harmonic mean gives equal weight to each data. Using the arithmetic mean in this case would give more weight to the higher-valued data, and thus the mean would be overstated.
How to calculate harmonic average in Excel?
To calculate harmonic mean in Excel use HARMEAN function.
Syntax is very simple:
HARMEAN(number1, [number2], …)
The formula I used is =HARMEAN(B2:B7)
As you may notice harmonic mean is much lower than arithmetic mean.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References