Documentation/Calc Functions/HARMEAN

Function name:
HARMEAN

Category:
Statistical Analysis

Summary:
Calculates the harmonic mean of a set of numbers. The harmonic mean is calculated by dividing the number count by the sum of the reciprocals of each number in the set.

Syntax:
HARMEAN(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a positive real number which is the harmonic mean of the set of numbers.

Arguments:
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers for which the harmonic mean is to be calculated.


 * If any of the arguments contain a value less than or equal to zero then the function returns an error value. However, empty cells and those with non-numeric (except for logical) values are ignored.

Additional details:

 * The formula for HARMEAN is:

where ai are the set of numbers passed as arguments and n is the size of that set. To find the value of n, use the function COUNT(N).
 * For more details on the harmonic mean, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUNT COUNT]

ODF standard:
Section 6.18.36, part 2

Equivalent Excel functions:
HARMEAN