In this Excel tutorial you will teach yourself when to use harmonic mean and how to calulate it 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], ...)

harmonic mean excel

The formula I used is =HARMEAN(B2:B7)

As you may notice harmonic mean is much lower than aritmetic mean.