How to Calculate a Weighted Average: Formula, Grades and Excel
How to calculate a weighted average: multiply each value by its weight, add them up and divide by the total weight. Grade, price and Excel examples.
By Muhammad Awais, Founder and editor-in-chiefPublished
To calculate a weighted average, multiply each value by its weight, add those products together, then divide by the total of the weights. If homework (20% of your grade) averages 92, quizzes (30%) average 85 and the final exam (50%) is 78, your grade is 0.2 × 92 + 0.3 × 85 + 0.5 × 78 = 82.9.
A plain average treats every number the same. A weighted average lets some numbers count more than others, which is how course grades, GPAs and average purchase prices work. For a course grade with categories, the grade calculator does this for you and also shows what you need on the final.
Step by step
- List each value and its weight. The weight is how much that value should count: a percentage of the grade, a number of credits, a quantity bought.
- Multiply each value by its weight.
- Add the products.
- Add the weights.
- Divide the sum of the products by the sum of the weights.
When the weights are percentages that add up to 100%, step 4 gives 1 (or 100), so you can skip the division. When they don’t add up to 100%, as with credits or quantities, the division is the step people forget.
Example 1: a course grade
| Category | Weight | Your average | Weight × average |
|---|---|---|---|
| Homework | 20% | 92 | 18.4 |
| Quizzes | 30% | 85 | 25.5 |
| Final exam | 50% | 78 | 39.0 |
| Total | 100% | 82.9 |
The weights add up to 100%, so the weighted average is simply 18.4 + 25.5 + 39.0 = 82.9. The plain average of the three scores, (92 + 85 + 78) ÷ 3 = 85.0, is higher, because the low final exam counts for half the grade.
Before the final: if you have only done homework and quizzes, divide by the weight you have completed. (18.4 + 25.5) ÷ 0.5 = 87.8 so far. To finish with 85 overall, you need (85 − 43.9) ÷ 0.5 = 82.2 on the final. This is the same sum as in what do I need on my final.
Example 2: GPA with credits
Credits are the weights. A 4-credit A (4.0), a 3-credit B (3.0) and a 1-credit C (2.0):
That rounds to a 3.38 GPA. Without weights the three grades would average 3.0, but the big 4-credit A pulls the result up. The GPA calculator works this out for a whole semester, including honors and AP weighting.
Example 3: average price paid
You buy the same stock three times:
| Purchase | Shares | Price per share | Cost |
|---|---|---|---|
| 1 | 100 | $20.00 | $2,000 |
| 2 | 50 | $26.00 | $1,300 |
| 3 | 150 | $18.00 | $2,700 |
| Total | 300 | $6,000 |
The weights are the share counts, so your average cost is $6,000 ÷ 300 = $20.00 a share. The plain average of the three prices, $21.33, is wrong here, because you bought far more at $18 than at $26. The same method gives the average price per unit of anything you buy in batches.
Example 4: from a frequency table
When a table shows how many times each value occurs, the counts are the weights. Ten students scored:
| Score | Students | Score × students |
|---|---|---|
| 70 | 3 | 210 |
| 80 | 5 | 400 |
| 90 | 2 | 180 |
| Total | 10 | 790 |
The class average is 790 ÷ 10 = 79. The mean, median and mode calculator gives the same answer if you type every score out, but the table method is quicker for big lists.
Weighted average in Excel and Google Sheets
Put the values in column B and the weights in column C (rows 2 to 4):
SUMPRODUCT multiplies each pair and adds the results, and SUM adds the weights. Excel has no separate weighted-average function, so this is the standard formula. Google Sheets has one built in:
If the weights are percentages that already add up to 100%, =SUMPRODUCT(B2:B4, C2:C4) on its own is enough.
Weighted vs simple average
| Simple average | Weighted average | |
|---|---|---|
| Every value counts | the same | by its weight |
| Formula | sum ÷ count | sum of value × weight ÷ sum of weights |
| Use it for | equal items: daily temperatures, test scores in one list | grades by category, GPA by credits, prices by quantity |
When every weight is the same, the two give the same answer.
Common mistakes
- Not dividing by the total weight. With credits or quantities the weights rarely add up to 1, so skipping the division gives a number that is far too big.
- Averaging averages. Class A has 20 students averaging 80 and class B has 30 averaging 70. The combined average is (20 × 80 + 30 × 70) ÷ 50 = 74, not 75, because class B is bigger.
- Mixing 0.2 and 20. Use either decimals (0.2, 0.3, 0.5) or whole percentages (20, 30, 50) for all the weights, then divide by their total (1 or 100).
- Leaving out a category with a zero. A missing assignment scored 0 still counts in the weighted total. Only categories you haven’t reached yet are left out.
Need a percentage of the total first, such as 46 out of 50 points? Work it out with the percentage calculator, then use it as the value.
FAQ
What is the formula for a weighted average?
Multiply each value by its weight, add the products and divide by the sum of the weights: Σ(value × weight) ÷ Σ(weight). With weights of 20%, 30% and 50% and values of 92, 85 and 78, that is 82.9.
How do I calculate a weighted average when the weights don’t add up to 100?
Divide by the total of the weights. Credits of 4, 3 and 1 with grade points of 4.0, 3.0 and 2.0 give 27 ÷ 8 = 3.375.
How do I calculate a weighted average in Excel?
Use =SUMPRODUCT(values, weights)/SUM(weights), for example =SUMPRODUCT(B2:B4, C2:C4)/SUM(C2:C4). Google Sheets also has =AVERAGE.WEIGHTED(values, weights).
Is a weighted average always lower than a simple average?
No. It moves towards the values with the biggest weights. In the grade example it was lower (82.9 vs 85.0) because the lowest score had the biggest weight; in the GPA example it was higher (3.375 vs 3.0) because the best grade had the most credits.
How is a weighted grade calculated?
Each category’s average is multiplied by its share of the grade, and the results are added. The grade calculator does this for any number of categories and tells you the score you need on the final.
Sources
- Microsoft Support: SUMPRODUCT function, used for weighted averages in Excel.
- Google Docs Editors Help: AVERAGE.WEIGHTED, the built-in weighted average in Google Sheets.