The HARMEAN function returns the harmonic mean of the specified number values.
HARMEAN(pos-num, pos-num…)
pos-num: A number value greater than 0.
pos-num…: Optionally include one or more additional positive number values.
Notes
The harmonic mean is the reciprocal of the arithmetic mean of the reciprocals of the arguments.
Example |
|---|
=HARMEAN(1, 2, 8) returns 1.84615386415385. This is calculated by first adding together the reciprocals of the arguments [1/1+1/2+1/8=13/8], then obtaining the arithmetic mean thereof [13/8*1/3=13/24], and finally taking the reciprocal of that mean [24/13 or 1.84615386415385]. |