How to Average Test Scores, and When a Simple Average Isn’t Enough

Three graded test papers with scores 72, 85 and 92 next to a balance scale, how to average test scores.

How to Average Test Scores: Say you’ve got three test scores back- 72, 85, and 92. You want one number that sums up how the term is going. You could type them into an average calculator and be done in five seconds. But it’s worth knowing what that number means, because plenty of situations that look like a simple average aren’t one and getting them wrong can quietly change your result by several points. This guide covers the basic method, the cases where it breaks, and how to work out what you need on your next test.

The basic method: add them up, divide by how many

Add all your scores together, then divide by the number of scores.
For 72, 85, and 92:

  • 72 + 85 + 92 = 249
  • 249 ÷ 3 = 83

That’s the whole thing. With two scores, the average is simply the midpoint between them:

  • 70 and 100 → 170 ÷ 2 = 85
  • 81 and 100 → 181 ÷ 2 = 90.5
  • 100 and 75 → 175 ÷ 2 = 87.5

A quick sanity check: your average must land somewhere between your lowest and highest score. If you get 95 from scores that top out at 92, an addition slipped somewhere.

A shortcut for doing it in your head

Pick a round number near the middle of your scores and see how far each one sits from it. For 72, 85, and 92, use 85 as the anchor:

  • 72 is 13 below, 85 is on the mark, 92 is 7 above.
  • The differences add up to −6. Divide by 3 to get −2.
  • 85 − 2 = 83.

It’s the same answer, and for bigger lists of similar numbers it’s often faster than adding everything up.

When a simple average gives the wrong answer

A simple average treats every number as equally important. That’s only true when every number really is.

Weighted grades

Suppose your course counts homework for 20%, quizzes for 30%, and the exam for 50%. Your scores so far: 90 on homework, 80 on quizzes, and 70 on the exam.
A straight average gives (90 + 80 + 70) ÷ 3 = 80. But the exam carries half the grade, so that’s too generous. The weighted version multiplies each score by its weight:

  • 90 × 0.20 = 18
  • 80 × 0.30 = 24
  • 70 × 0.50 = 35
  • 18 + 24 + 35 = 77

Three points lower, and that’s the number your grade will actually reflect. If your weights add up to 100%, you don’t need to divide afterward. If they don’t (say they’re expressed as 2, 3, and 5), divide the total by the sum of the weights. The formal definition of a weighted mean.
If your school weights by credit hours rather than percentages, that’s what a GPA calculator is built for.

Averaging averages

This one catches people constantly. Class A has 20 students and averaged 80. Class B has 5 students and averaged 90. What’s the average across both classes?
The tempting answer is (80 + 90) ÷ 2 = 85. But Class A has four times as many students, so it should pull harder on the result. Treat the class sizes as weights:

  • (20 × 80 + 5 × 90) ÷ 25
  • (1,600 + 450) ÷ 25 = 2,050 ÷ 25 = 82

The same trap shows up with monthly averages when months have different numbers of days, with store branches of different sizes, and with percentages scored out of different totals. An 8/10 quiz and a 45/100 exam average to 62.5% if you average the percentages, but 53 out of 110 points is 48.2%. The rule is the same each time: when the groups aren’t the same size, weight by size. If they are the same size, the simple average of averages is fine.

One score that’s way off

Take 92, 90, 88, 91, and 40. The average is 80.2, which suggests a middling student. But four of the five scores sit between 88 and 92, and the median (the middle value when sorted) is 90. One bad day, one missed section, or one typo is dragging the average down.

When the mean and median are far apart, that’s a signal that something unusual is in your data. A calculator that shows the mean and median together makes that gap visible straight away.

What score do you need next?

Often the real question isn’t “what’s my average?” but “what do I need to reach my target?”

With equal-weight tests. You have 72, 85, and 92 and one more test to go. You want an overall average of 85 across four tests. Four tests at an average of 85 means a total of 340 points. You have 249, so you need 91 on the last one.

With a weighted final. Homework (20%) and quizzes (30%) are finished, with scores of 90 and 80. The final is worth 50% and you want a course grade of 80.

  • What you’ve already banked: 0.20 × 90 + 0.30 × 80 = 18 + 24 = 42
  • Still needed from the final’s share: 80 − 42 = 38
  • Divide by the final’s weight: 38 ÷ 0.50 = 76

You need a 76 on the final. Check whether that target is realistic before you plan around it, since it’s possible for the answer to come out above 100.

Doing it in a spreadsheet

In Excel or Google Sheets, a plain average of scores in cells A2 to A6 is:
=AVERAGE(A2:A6)
For a weighted average, with scores in A2:A4 and weights in B2:B4:
=SUMPRODUCT(A2:A4, B2:B4)/SUM(B2:B4)

Where a calculator fits in

Working by hand is fine for three or four numbers and worth doing once so you understand the result. For a longer list, or to double-check your arithmetic, you can enter your list into the average calculator. It accepts numbers separated by commas, spaces, or line breaks, and it returns the median and spread along with the mean. It calculates simple averages, so for weighted grades or averaging averages, use the methods above.

Frequently asked questions

Is “average” the same as “mean”?

In everyday use, yes. When people say average they almost always mean the arithmetic mean: the sum divided by the count. Statisticians use “average” more loosely, which is why median and mode are sometimes called averages too.

Should I round my scores before averaging?

No. Keep full precision through the calculation and round only the final answer. Rounding each score or interim average first can shift the result.

What happens to blank cells and zeros in a spreadsheet?

AVERAGE skips empty cells and text but counts zeros. A missing score left blank won’t affect the average, while the same score entered as 0 will pull it down. Make sure each cell says what you mean it to.

GPA Calculator – If you’re working with grades specifically, the converts letter grades and credit hours into a grade point average.

Percentage Calculator – If you need to work out a percentage change, a percentage of a total, or convert a fraction to a percentage.

Scroll to Top