Manuals/calci/HARMEAN

HARMEAN (N1, N2...)

Where N1, N2 ... n1, n2 etc are parameters. You can also give as an array or use array reference.

Calci returns the harmonic mean of a data set. It is the reciprocal of the arithmetic mean of reciprocals.

· HM <GM<AM.

· The values are ignored, when an array or reference argument contains text, logical values, or empty cells.

· Logical values and text representations of numbers are counted.

· HARMEAN calculates an error value, when any data point ≤ 0.

Formulas:-

To find out the harmonic mean, the equation is:

HARMEAN

Lets see an example in (Column1, Row1)

=HARMEAN (B1:B6) That is

=HARMEAN(5,6,7,9,12,13) is 7.68

Syntax

Remarks

Examples

Description