It is simply calculated by taking a sum of all the data. 3 Now we can calculate the weighted average by dividing the SSUMPRODUCT with the SUM of the weightage assigned. As you can see there is a bit of difference between the two results.
Using the same example as we did for the arithmetic mean the geometric mean calculation equals.
First the AVERAGE function below calculates the normal average of three scores. GEOMEAN49 returns 6. The Excel HARMEAN function returns the harmonic mean for a set of numeric values. The weighted average geometric mean can be calculated using this formula.