In other words, the harmonic mean is the reciprocal of the average of the reciprocals.
The HARMEAN function takes multiple arguments in the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range.
Examples
The average of 1, 2, and 6 is 3.
TRIMMEAN Function
The Excel TRIMMEAN function calculates mean (average) while excluding outliers.
The number of data points to exclude is provided as a percentage.
GEOMEAN Function
The Excel GEOMEAN function returns the geometric mean for a set of numeric values.
Geometric mean can be used to calculate average rate of return with variable rates.
