## Harmonic Mean in Excel

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

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```
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell