The Harmonic Mean formula is:
HM = 1.5 / (0.5/A + 0.5/B + 0.5/C )
Where: A, B, and C = sample data
0.5 is the assigned weight for each sample
1.5 is the total assigned weight for all samples
Given only two samples, the formula becomes:
HM = 1 / ( 0.5/A + 0.5/B )
The manual calculation of Harmonic Mean becomes tedious as the number of samples increases.
OpenOffice Calc spreadsheet uses the following formula in calculating for the Harmonic Mean:
= harmean ( range of cells of the sample data )
No comments:
Post a Comment