Returns the harmonic mean of a data set.
Składnia
HARMEAN(number1, [number2], ...)Argumenty
number1wymagane
The first number or range of numbers to include in the calculation.
number2opcjonalne
Additional numbers or ranges up to 255 total arguments.
The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. It is most appropriate for averaging rates or ratios, such as speed or price-to-earnings ratios.
=HARMEAN(10, 20, 40)→17.142857Calculates the harmonic mean of 10, 20, and 40.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =HARMEAN( followed by your data range or numbers, then close the parenthesis.
Calculate
Press Enter to display the harmonic mean.
HARMEAN returns a #NUM! error if any data point is less than or equal to zero.