Documentation/Calc Functions/HARMEAN

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

HARMEAN

Category:

Statistical Analysis

Summary:

Returns the harmonic mean of a data set.

Syntax:

HARMEAN(Number1; Number2; ...; Number30)

Returns:

Arguments:

Number1, Number2, ..., Number30 are up to 30 values or ranges, that can be used to calculate the harmonic mean.

Additional details:

Examples:

=HARMEAN(23;46;69) = 37.64. The harmonic mean of this random sample is thus 37.64

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: