Manuals/calci/HARMEAN
Jump to navigation
Jump to search
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
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 7.683527 | ||
| Row2 | 6 | |||
| Row3 | 7 | |||
| Row4 | 9 | |||
| Row5 | 12 | |||
| Row6 | 13 |
