How to Calculate an Average (Mean, Median, Mode and Weighted)
An average is a single number that represents a group of numbers. Usually “average” means the mean: add everything up and divide by how many numbers there are. But the median and mode are also averages, and each suits different situations.
Quick answer
- Mean (average): sum ÷ count. The average of 4, 8 and 9 is 21 ÷ 3 = 7.
- Median: the middle value when the numbers are in order.
- Mode: the value that appears most often.
Worked example
Test scores: 72, 85, 90, 64, 85, 96, 78.
- First, add them: 72 + 85 + 90 + 64 + 85 + 96 + 78 = 570.
- Then count them: 7.
- Finally, divide: 570 ÷ 7 = 81.43.
For the median, sort them: 64, 72, 78, 85, 85, 90, 96. The middle (4th) value is 85. The mode is 85, the only score that appears twice.
Mean, median or mode?
| Average | Best when | Example |
|---|---|---|
| Mean | Values are fairly evenly spread | Average test score |
| Median | There are extreme values (outliers) | Typical house price or income |
| Mode | You want the most common value | Most popular shoe size |
One very large value can pull the mean up a lot, whereas the median barely moves. That’s why incomes and house prices are often reported as medians.
Median with an even number of values
If there’s no single middle number, average the two middle values. For 3, 5, 8, 10, the median is (5 + 8) ÷ 2 = 6.5.
Weighted average
When some values count more than others, multiply each by its weight, add the results, and divide by the total weight. If homework (weight 20%) is 90, the midterm (30%) is 75 and the final (50%) is 82, the weighted average is 0.2 × 90 + 0.3 × 75 + 0.5 × 82 = 81.5. GPA works the same way; see how to calculate GPA.
In Excel or Google Sheets
- Mean:
=AVERAGE(A1:A10) - Median:
=MEDIAN(A1:A10) - Mode:
=MODE(A1:A10) - Weighted:
=SUMPRODUCT(A1:A3, B1:B3)/SUM(B1:B3)
Frequently asked questions
How do you calculate an average?
Add all the numbers and divide by how many there are.
What’s the difference between mean and median?
The mean is the sum divided by the count; the median is the middle value in order.
How do I calculate a weighted average?
Multiply each value by its weight, add them, and divide by the sum of the weights.
What is the average of 10, 20 and 30?
20.
