|

How to Calculate an Average (Mean, Median, Mode and Weighted)

How to Calculate an Average: Mean, median, mode, weighted
Spread the love

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.

  1. First, add them: 72 + 85 + 90 + 64 + 85 + 96 + 78 = 570.
  2. Then count them: 7.
  3. 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.

Related guides

Related guides

Leave a Reply

Your email address will not be published. Required fields are marked *