Worksheet to find Weighted Mean

Weighted Mean is an average calculated by giving different weights to some of the individual values. If all the weights are equal, then the weighted mean is the same as the arithmetic mean. The weights cannot be negative. This worksheet help you to understand how to calculate weighted mean.

Formula:

Where
x is the repeating value
w is the number of occurrences of x (weight)
x̄ is the weighted mean

Example problem:
X = 5,20,40,80,100
Weighted mean = (W1X1+W2X2+W3X3+...WnXn)/(W1+W2+W3+...Wn)

Weighted mean = (5+40+120+320+500)/ (5+20+40+80+100)

Weighted mean = ( 985) /(245)

Weighted mean = 4.020408163265306

Weighted mean (rounded) = 4.0204

When you try such calculations on your own, this weighted mean calculator can be used to verify the results of your calculations.