Here’s what’s happening under the hood

[hoxesi8100@]

1. I enter my data into a spreadsheet and then add a column containing the weight for each data point.
sumproduct to calculate weighted average in excel step 1

2. Next, I type =SUMPRODUCT to start the formula and enter the values.
sumproduct to calculate weighted average in excel step 2

3. Finally, I click enter to get my results.
sumproduct to calculate weighted average in excel step 3


First, the equation multiplies each score by its weight:

86 x 15 = 1290
55 x 10 = 550
78 x 20 = 1560
92 x 15 = 1380
64 x 40 = 2560
Next, it combines these values:

1290 + 550 + 1560 + 1380 + 2560 = 7340
Finally, the equation divides belarus phone number material the combined value by the total value of our weights:

7340 / (15 + 10 + 20 + 15 + 40) = 73.4
How to Find Weighted Moving Averages in Excel
A useful variation on the weighted moving average is the weighted moving average.

When I use a weighted moving average, I can calculate the average over a set period even as I add new data or give more weight to certain values. This can help identify trends and patterns more easily.