Weighted average calculator

Enter each value with how much it counts. Weights can be percentages, credits, quantities or any numbers.

ValueWeight

Weighted average

-

The working

How to calculate a weighted average

weighted average = Σ (value × weight) ÷ Σ weights

  1. Multiply each value by its weight.
  2. Add up those results.
  3. Add up the weights.
  4. Divide the first total by the second.

Example: 80 with weight 2, 90 with weight 3, 70 with weight 1 gives (160 + 270 + 70) ÷ 6 = 83.33. The plain average of the three values is 80, but 90 counts three times as much as 70, so the weighted average is higher.

Example: a class grade

Most class grades are weighted averages, with each category worth a share of the final grade:

CategoryWeightScoreScore × weight
Homework20%92%1,840
Quizzes30%78%2,340
Final exam50%85%4,250
Total100%8,430

8,430 ÷ 100 = 84.3%. Before the final exam, only homework and quizzes have scores, so divide by the weight completed so far (50), not by 100: the grade so far is 83.6%. Dividing by 100 would wrongly give 41.8%. The grade calculator does this for you, and the final grade calculator shows what you need on the final.

Example: average price paid

If you buy 100 at 10 each and then 50 at 16 each, the average price isn't (10 + 16) ÷ 2 = 13. You bought twice as many at the lower price, so weight each price by the quantity: (100 × 10 + 50 × 16) ÷ 150 = 12. The same method gives the average cost of shares bought at different prices, or the average rate across loans of different sizes.

The most common mistake: averaging averages

Class A has 20 students with an average of 70; Class B has 30 students averaging 80. The average across all 50 students isn't 75, it's 76, because Class B has more students. Whenever you combine averages, percentages or rates from groups of different sizes, weight each one by its group size.

Where weighted averages come up

If every weight is the same, the weighted average equals the ordinary mean. For a plain average, median and mode, use the mean, median and mode calculator.

Questions people ask

What is a weighted average?

An average where some values count more than others. Each value is multiplied by its weight, the results are added up, and the total is divided by the sum of the weights.

How is it different from a normal average?

A normal (mean) average gives every value a weight of 1. If all your weights are equal, the weighted average and the mean are the same.

How do I calculate a weighted average in Excel or Google Sheets?

Put the values in one column and the weights in the next, then use =SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10). SUMPRODUCT multiplies each value by its weight and adds them up; dividing by SUM of the weights gives the weighted average.

Can I average percentages?

Only if each percentage is based on the same number of things. Otherwise weight each percentage by its size: 90% of 10 questions and 70% of 40 questions is 74% overall, not 80%.

Do the weights need to add up to 1 or 100?

No. Because you divide by the total weight, weights of 2, 3 and 5 give the same answer as 20%, 30% and 50%.

Also in the notebook