How to Calculate the Harmonic Mean

Reviewed by Anne Schmidt

Last Updated: January 30, 2023 Fact Checked

The harmonic mean is a way to calculate the mean, or average, of a set of numbers. Using the harmonic mean is most appropriate when the set of numbers contains outliers that might skew the result. Most people are familiar with calculating the arithmetic mean, in which the sum of values is divided by the number of values. Calculating the harmonic mean is a little more complicated. If working with a small set of numbers you may be able to solve by hand using the formula. Otherwise, you can easily use Microsoft Excel to find the harmonic mean.

Method 1

Method 1 of 3:

Setting Up the Formula

Download Article

The formula is ${\frac {n}{{\frac {1}{a_{{1}}}}+{\frac {1}{a_{{2}}}}+{\frac {1}{a_{{3}}}}+...+{\frac {1}{a_{{n}}}}}}$ , where $n$ is the number of values in the set of numbers, and $a_{{1}}$ , $a_{{2}}$ , $a_{{3}}...$ are the values in the set. ^{[1]
X
Research source}
2
Determine the values you need to find the harmonic mean for. This can be any set of numbers. ^{[2]
X
Research source}
- For example, you may need to find the harmonic mean for the numbers 10, 12, 16, and 8.
Advertisement
3
Plug the value of $n$ into the formula. This will equal the number of values in your set.
- For example, if you are finding the harmonic mean of the numbers 10, 12, 16, and 8, you are working with 4 values, the numerator of your formula will be 4:
  ${\frac {4}{{\frac {1}{a_{{1}}}}+{\frac {1}{a_{{2}}}}+{\frac {1}{a_{{3}}}}+...+{\frac {1}{a_{{n}}}}}}$
4
Plug the values your are averaging into your formula. You will take the reciprocal of each number and add them in the denominator of the formula. Remember, when you take the reciprocal of a whole number, you turn the number into a fraction by placing a 1 in the numerator and the whole number in the denominator. ^{[3]
X
Research source}
- For example, if the values in your set are 10, 12, 16, and 8, you would place the fractions ${\frac {1}{10}}$ , ${\frac {1}{12}}$ , ${\frac {1}{16}}$ , ${\frac {1}{8}}$ in your denominator:
  ${\frac {4}{{\frac {1}{10}}+{\frac {1}{12}}+{\frac {1}{16}}+{\frac {1}{8}}}}$

Method 2

Method 2 of 3:

Calculating the Harmonic Mean by Hand or Calculator

Download Article

1
Add the fractions in the denominator. You can use a calculator, or add them up by hand. If you are not using a calculator, remember to find a common denominator first. To learn more about adding fractions, read Add Fractions .
- For example:
  ${\frac {4}{{\frac {1}{10}}+{\frac {1}{12}}+{\frac {1}{16}}+{\frac {1}{8}}}}={\frac {4}{{\frac {89}{240}}}}$
2
Divide the numerator by the denominator. Remember that dividing by a fraction is the same as multiplying by its reciprocal. ^{[4]
X
Research source}
- For example:
  ${\frac {4}{{\frac {89}{240}}}}$
  $=4\times {\frac {240}{89}}$
  $={\frac {4}{1}}\times {\frac {240}{89}}$
  $={\frac {960}{89}}$
3
Convert to a decimal to find the harmonic mean of your set of numbers. To convert a fraction to a decimal, divide the numerator by the denominator. ^{[5]
X
Research source}
- For example:
  ${\frac {960}{89}}$
  $=960\div 89$
  $=10.79$
  So, the harmonic mean of the numbers 10, 12, 16, and 8 is 10.79.

Method 3

Method 3 of 3:

Calculating the Harmonic Mean using Excel

Download Article

1
Enter the values into your spreadsheet. Make sure to only place one value in each cell.
- For example, if you need to find the harmonic mean of 10, 12, 16, and 8, you might type each of these values into a separate cell in the spreadsheet, cells A1-A4.
2
Enter the function for the harmonic mean. The function is HARMEAN(number 1, [number 2]...). ^{[6]
X
Research source} To select the function, begin typing “=HARMEAN” into a blank cell of the spreadsheet, then double-click on the function when it pops up.
- For example, type “=HARMEAN” into cell A5 of your spreadsheet and double-click on the function.
3
Highlight the cells containing the values you are averaging. Hit the enter key. Excel will calculate the harmonic mean for you and display it in the spreadsheet.
- For example, highlight cells A1-A4 of your spreadsheet and hit enter. Excel will calculate 10.78652 as the harmonic mean.

Community Q&A

Search

Add New Question

Question

What are the harmonic means of 5, 6 and 7?

Community Answer

3/(1/5+1/6+1/7) = 3/(42/210 + 35/210 + 30/210 ) = 3/( 107/210) = 3 x 210/107= 630/107 = 5.89

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 18
Question

What is the harmonic mean of x1,x2,x3.xn?

Community Answer

This is just asking for the formula: n/(1/x1 + 1/x2 + 1/x3 +...+1/xn)

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 10 Helpful 17
Question

Can you tell me the harmonic mean of 0 2 4 6?

Donagan

Top Answerer

There's no harmonic mean when zero is one of the values in the set. That's because the formula would have 1/0 as one of the terms in the denominator, and 1/0 is infinity and not usable.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 5 Helpful 11

See more answers

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

Tips

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!

You Might Also Like

[1]

[2]

[3]

[4]

[5]

[6]

Log in

How to Calculate the Harmonic Mean

Steps

Setting Up the Formula

Calculating the Harmonic Mean by Hand or Calculator

Calculating the Harmonic Mean using Excel

Community Q&A

Video

Tips

You Might Also Like

References

About This Article

Reader Success Stories

Did this article help you?

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Quizzes

Explore Categories