HARMEAN(list)

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:

image\ebx_-1893600234.gif

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:

Other statistical functions