HARMEAN
Returns the harmonic mean.
StatisticalStatistics & Analysis
What it does
Calculates the harmonic mean (reciprocal of the arithmetic mean of reciprocals).
Syntax
HARMEAN(number1, [number2], ...)
Arguments
number1(number) — First number.
Examples
Average Speed
Mean of 60 and 40.
FORMULA
=HARMEAN(60, 40)
RESULT
48
SAMPLE DATA
| A | |
|---|---|
| 1 | Speeds |
| 2 | 60 |
| 3 | 40 |