HARMEAN function - The function returns the harmonic average of a data set in Excel

The following article introduces you to HARMEAN function - one of the functions in the statistical function group is very popular in Excel.

HARMEAN function - The function returns the harmonic average of a data set in Excel Picture 1

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:

HARMEAN function - The function returns the harmonic average of a data set in Excel Picture 2

- In the cell to calculate enter the formula : = HARMEAN (D6: D10)

HARMEAN function - The function returns the harmonic average of a data set in Excel Picture 3

- Press Enter -> harmonic average of number values is:

HARMEAN function - The function returns the harmonic average of a data set in Excel Picture 4

- Where number values ​​are logical or text values ​​-> they are ignored:

HARMEAN function - The function returns the harmonic average of a data set in Excel Picture 5

Above are instructions and some specific examples when using HARMEAN function in Excel.

Good luck!