The weighted average of the time you spent working out for the month is 209 minutes. The WMA is obtained by multiplying each number in the data set by a predetermined weight and summing up the resulting values. X w b y w.
If all the weights are equal then the weighted mean is the same as the arithmetic mean.
Weighted Mean formula can be applied to calculate the average returns from a portfolio comprising of different financial instruments. Mean 1 2 3 44 104 25. In Excel we use two functions to calculate the weighted average in excel. Weighted Average WeightsQuantities Weights Weighted Average Weights Quantities Weights.