Excel Insider
Averages & Mean Calculators

Harmonic Mean Calculator

The perfect tool for averaging rates or ratios — like speed (km/h) or price-earnings ratios in finance.

A precise average for fractions and rates that a normal average would get wrong.

Enter rate or ratio data
Speeds, rates, ratios — data where a regular average quietly lies to you.

Preset loaded. Ideal for speeds & rates.

Harmonic mean

40

The true average of your rates — not the misleading arithmetic one

Arithmetic mean

45

For comparison — always ≥ HM

Count (n)

2

Sum of reciprocals

0.0500

Σ(1 ÷ xᵢ) — the denominator

Step by step

  1. 1

    Formula

    HM = n ÷ Σ(1 ÷ xᵢ)

  2. 2

    Reciprocals

    1/30 = 0.0333 · 1/60 = 0.0167

  3. 3

    Result

    2 ÷ 0.0500 = 40

The arithmetic mean of the same data is 45 — but rates average by time, not by trip. The harmonic mean weighs every value by how long it holds, which is why it is always the lower, truer number.

About this calculator

If you drive to work at 60 mph and come back at 40 mph, most people say the average speed is 50 mph — that answer is wrong. A regular average fails with rates, speeds and ratios: it gives you a number that looks right but leads you astray. This matters in physics, engineering and finance, where a wrong number can cost you dearly.

The harmonic mean is the average for values linked by units — speed is distance over time, density is mass over volume. It is one of the three Pythagorean means: the arithmetic mean adds numbers directly, while the harmonic mean uses their reciprocals instead.

Formula

HM = n ÷ Σ(1 ÷ xᵢ) = n ÷ (1/x₁ + 1/x₂ + … + 1/xₙ)

How to use it

  1. 1

    Enter your rates or ratios — comma separated, positive numbers only.

  2. 2

    The calculator sums the reciprocals and divides the count by that sum.

  3. 3

    Read the true average, plus the arithmetic mean and the reciprocal sum for comparison.

A simple example — the speed paradox

Trip A at 60 mph, Trip B at 40 mph. Reciprocals: 1/60 = 0.0167 and 1/40 = 0.0250. Sum: 0.0417. Divide the count 2 by the sum → 48 mph. The 50 mph guess ignores driving time — you spend more time at 40 than at 60, and the harmonic mean handles that difference correctly.

1. It gives the lowest average

The harmonic mean always stays lowest of the three Pythagorean means: Harmonic ≤ Geometric ≤ Arithmetic. Small numbers affect it the most while large values barely move it — if one value approaches zero, the harmonic mean drops toward zero too.

2. It does not work with zero

The formula divides by each number, and dividing by zero is undefined in mathematics. The calculator shows an error for zero inputs. It also struggles with negative values — a speed of −50 mph does not work in normal driving problems, which is why temperature-style data needs a different tool.

3. It helps with parallel tasks

Physicists and engineers use the harmonic mean for tasks that happen together at different rates — parallel resistors, pumps filling a tank, workers on the same job. If two pumps fill one tank together, harmonic mean math finds the total filling time.

In Excel: In Excel use =HARMEAN(range).

Frequently asked questions

Why is my result lower than the regular average?

That is normal. The harmonic mean gives more weight to smaller numbers — low values affect the final answer more than large values do, so the result usually stays below the arithmetic mean.

Can I use negative numbers?

Generally, no. You can put negative numbers into the formula, but the result rarely makes sense in real situations — a speed of −50 mph does not work in normal driving problems. The harmonic mean works best with positive rates and ratios.

What happens if I enter 0?

The calculator shows an error. The formula divides by each number in the list, and mathematics does not allow division by zero — the calculation cannot continue.

How does harmonic mean compare with geometric mean?

Each average fits a different type of problem. Use the geometric mean for growth rates and compound interest. Use the harmonic mean for speeds, rates and resistance. Use the arithmetic mean for simple counting values such as test scores or apples.