The following article introduces you to HARMEAN function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the harmonic mean of a dataset, the harmonic mean is the reciprocal of the arithmetic mean of the reciprocals.
Syntax: HARMEAN (number1, [number2], .)
Inside:
- number1, [number2], .) : The values you want to calculate the harmonic mean value, where number1 is the required parameter, the remaining values are optional and contain up to 255 number parameters .
Attention:
- Note: harmonic average
- Arguments can be numbers, names or arrays that contain numbers.
- When typing logical values or textual numbers directly -> these values are still counted.
- If the reference argument or array contains logical values or text -> these values are ignored, but a value of 0 is still counted.
- The value of the argument is a text or an error value that cannot be converted. The function will report an error.
- If any data point ≤ 0 -> the function returns the #NUM! Error value
- The average harmonic equation is:
[frac {1} {{{H_y}}} = frac {1} {n} sum {frac {1} {{{Y_i}}}}]]
For example:
Calculate the harmonic mean of number values in the following data table:
- In the cell to calculate enter the formula : = HARMEAN (D6: D10)
- Press Enter -> harmonic average of number values is:
- Where number values are logical or text values -> they are ignored:
Above are instructions and some specific examples when using HARMEAN function in Excel.
Good luck!