Weighted Harmonic Mean
The weighted harmonic mean of the selection based on a specified weighting column.
Weighted Harmonic Mean is calculated the same way as the Harmonic Mean. The Harmonic Mean is defined as a special case where all of the weights are equal to 1 and is equivalent to any weighted harmonic mean where all weights are equal.
The formula:
If a set of
weights
is associated to the dataset
the weighted
harmonic mean is defined by
Sample 1:
As a simple example, the Weighted Harmonic Mean of 1, 2, and 4 given the weights 5, 6, 7 respectively is:
18/ (5/1 + 6/2 + 7/4) = 18/9.75 = 1.8462