Calculate the Harmonic Mean

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.[1] 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.

Steps

Setting Up the Formula

  1. Set up the formula for the harmonic mean. The formula is <math>\frac{n}{\frac{1}{a_{1}} + \frac{1}{a_{2}} + \frac{1}{a_{3}} +...+\frac{1}{a_{n}}}</math>, where <math>n</math> is the number of values in the set of numbers, and <math>a_{1}</math>, <math>a_{2}</math>, <math>a_{3}...</math> are the values in the set.[2]
  2. Determine the values you need to find the harmonic mean for. This can be any set of numbers.
    • For example, you may need to find the harmonic mean for the numbers 10, 12, 16, and 8.
  3. Plug the value of <math>n</math> 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:
      <math>\frac{4}{\frac{1}{a_{1}} + \frac{1}{a_{2}} + \frac{1}{a_{3}} +...+\frac{1}{a_{n}}}</math>
  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.[3]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.
    • For example, if the values in your set are 10, 12, 16, and 8, you would place the fractions <math>\frac{1}{10}</math>, <math>\frac{1}{12}</math>, <math>\frac{1}{16}</math>, <math>\frac{1}{8}</math> in your denominator:
      <math>\frac{4}{\frac{1}{10} + \frac{1}{12} + \frac{1}{16} + \frac{1}{8}}</math>

Calculating the Harmonic Mean by Hand or Calculator

  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:
      <math>\frac{4}{\frac{1}{10} + \frac{1}{12} + \frac{1}{16} + \frac{1}{8}} = \frac{4}{\frac{89}{240}}</math>
  2. Divide the numerator by the denominator. Remember that dividing by a fraction is the same as multiplying by its reciprocal.[4]
    • For example:
      <math>\frac{4}{\frac{89}{240}}</math>
      <math>= 4 \times \frac{240}{89}</math>
      <math>= \frac{4}{1} \times \frac{240}{89}</math>
      <math>= \frac{960}{89}</math>
  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]
    • For example:
      <math>\frac{960}{89}</math>
      <math>= 960 \div 89</math>
      <math>= 10.79</math>
      So, the harmonic mean of the numbers 10, 12, 16, and 8 is 10.79.

Calculating the Harmonic Mean using Excel

  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] 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.



Related Articles

Sources and Citations

  1. ↑ http://economistatlarge.com/finance/applied-finance/differences-arithmetic-geometric-harmonic-means
  2. ↑ http://www.ck12.org/book/CK-12-Probability-and-Statistics-Concepts/section/5.3/
  3. ↑ http://www.mathwords.com/h/harmonic_mean.htm
  4. ↑ https://www.mathsisfun.com/fractions_division.html
  5. ↑ http://www.purplemath.com/modules/percents2.htm
  6. ↑ https://support.office.com/en-us/article/HARMEAN-function-5efd9184-fab5-42f9-b1d3-57883a1d3bc6
Retrieved from "https://kipkis.com/index.php?title=Calculate_the_Harmonic_Mean&oldid=351113"