The HARMEAN function calculates the harmonic mean of a list of numbers. This is the reciprocal of the arithmetic mean of reciprocals.
Each number x of the list should be > 0. The harmonic mean is always less than the geometric mean, which is always less than the arithmetic mean, for the list of numbers.
The formula for the harmonic mean is:
where n is the size of the list and x1 ,x2 …. xn are the numbers in the list.
For example,
HARMEAN(10, 5, 4, 7, 8)
returns 6.113537, given by 5/(1/10 + 1/5 + 1/4 + 1/7 + 1/8).
See also: