Harmonic mean is calculated by dividing the number of observations n by the sum of reciprocals of all observations. The Excel HARMEAN function returns the harmonic mean for a set of numeric values. Harmonic Mean N 1a 1 1a 2 1a 3 1a 4 1a N Where X Individual score N Sample size Number of scores This tool will help you dynamically to calculate the statistical problems.
Select a blank cell and type this formula SUMPRODUCT B2.
The harmonic mean is always less than the geometric mean which is always less than the arithmetic mean. Harmonic mean n 1x_i Where. Harmonic mean is calculated by dividing the number of observations n by the sum of reciprocals of all observations. B5 represents the weights and the range C2.