To find a weighted average, multiply each number by its weight, then add the results. If the weights don't add up to one, find the sum of all the variables multiplied by their weight, then divide by the sum of the weights.
What is an example of a weighted average?
One of the most common examples of a weighted average is the grade you receive in a class. For example, the class syllabus could state that homework is 20% of your final grade, quizzes 30%, and exams 50%. ... For example, in Major League Baseball, people calculate slugging percentage using a weighted average.
How do I calculate a weighted average in Excel?
To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.
- First, the AVERAGE function below calculates the normal average of three scores. ...
- Below you can find the corresponding weights of the scores. ...
- We can use the SUMPRODUCT function in Excel to calculate the number above the fraction line (370).
