**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