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], …)

harmonic mean excel

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

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


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell