Skip to content
KazamTools

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 , 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.

Weighted average = (value₁ × weight₁ + value₂ × weight₂ + …) ÷ (weight₁ + weight₂ + …)

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

  1. 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.
  2. Multiply each value by its weight.
  3. Add the products.
  4. Add the weights.
  5. 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):

(4 × 4.0 + 3 × 3.0 + 1 × 2.0) ÷ (4 + 3 + 1) = 27 ÷ 8 = 3.375

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(B2:B4, C2:C4) / SUM(C2:C4)

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:

=AVERAGE.WEIGHTED(B2:B4, C2:C4)

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