A weighted average is an average where each value has a different level of importance, represented by a weight, which affects the overall calculation.
Contents:
Weighted Average Formula
The weighted average formula in Excel is the following:
= SUMPRODUCT(score_range, weight_range)So, if your scores are being held in range A1:A5, that would be your score_range, and if the weights are next to them in range B1:B5, that would be your weight_range.
*Note that the percentages of weights must sum up to 1 (or 100%) to get an accurate result
How to Calculate Weighted Average Grades
Let's say you have grades for a student, and each grade has different importance or weight.
A weighted average will change based on how a student performs in each category. The higher weighted tests will count for a larger portion of their overall grade, compared to the quizzes.
Both the weight of each category and the score is needed to calculate the weighted average so let's drop that in next to the weight.
Next to calculate the weighted average, we can use the following formula.
= SUMPRODUCT(C3:C10,D3:D10)
Which gives us a weighted average of 86%.
