Average calculator with a bar chart and average line icon on a dark background

Average Calculator: Mean, Median, Mode & Weighted Average

Last updated:

Use this average calculator to find the mean, median, mode and range of any list of numbers, or a weighted average when some values count more than others. Paste your numbers, press Calculate, and every step is worked out so you can check the answer yourself.

Separate numbers with commas, spaces or new lines. You can paste a column from Excel. Write 1000, not 1,000.

Enter each value with its weight. Weights are relative importance, so they do not need to add up to 100.

Enter your numbers, then press Calculate.

Average calculator examples

1. Test scores. The scores 85, 90, 78, 92, 88, 76, 95 and 88 add up to 692. Divided by 8 scores, the mean is 86.5. The median is 88, the mode is 88 and the range is 19.

2. Why the median matters. For incomes of 38,000, 42,000, 45,000, 47,000, 52,000 and 250,000, one very high value pulls the mean up to 79,000. The median is only 46,000, which is closer to what most people earn.

3. Two modes. In 2, 3, 3, 5, 7, 7, 9, the values 3 and 7 both appear twice, so the modes are 3 and 7. The mean is 5.1429 and the median is 5.

4. Negative and decimal numbers. The temperatures -3, 0, 2.5, 4 and -1.5 add up to 2, so the mean is 0.4. The median is 0 and there is no mode.

5. Weighted average. Homework 90 (20%), midterm 82 (30%) and final 76 (50%) give a weighted average of 80.6. The simple average of the three scores would be 82.67, which ignores that the final counts the most.

Results are rounded to the number of decimal places you choose. The mode is only shown when a value appears more than once. Standard deviation uses n – 1 for a sample and n for a whole population.

Quick answer: To find the average (the mean), add all the numbers and divide by how many there are. The average of 85, 90 and 80 is (85 + 90 + 80) ÷ 3 = 85. Use the median instead when a few extreme values would distort the mean.

How to Use the Average Calculator

  1. Choose List of numbers for a normal average, or Weighted average when each value has its own weight.
  2. Type or paste your numbers. Separate them with commas, spaces or new lines. You can paste a column straight from Excel.
  3. Press Calculate. The page jumps to your result and the steps.
  4. Not sure where to start? Press a Try example button below the calculator.

Write large numbers without commas (1000, not 1,000), because a comma is read as a separator.

How to Calculate the Mean

The mean is what most people mean by “average”:

Mean = sum of the values ÷ number of values

Take the test scores 85, 90, 78, 92, 88, 76, 95 and 88. They add up to 692, and there are 8 scores, so the mean is 692 ÷ 8 = 86.5.

Median: The Middle Value

The median is the middle number once the list is sorted from smallest to largest.

  • Odd count: the median is the middle value. In 3, 5, 7, 9, 11 it is 7.
  • Even count: average the two middle values. In 4, 6, 8, 10 the middle pair is 6 and 8, so the median is (6 + 8) ÷ 2 = 7.

Very large or very small values barely move the median, which is why it is used for incomes and prices.

Mode: The Most Frequent Value

The mode is the value that appears most often. A list can have one mode, several modes or none:

  • In 2, 3, 3, 5, 7, 7, 9 the values 3 and 7 both appear twice, so there are two modes.
  • In 4, 6, 8, 10 every value appears once, so there is no mode.

Some textbooks say there is no mode when every value appears equally often. This calculator reports every value that ties for the highest count, as long as that count is at least two.

Mean vs Median vs Mode: Which One Should You Use?

MeasureBest forWeak spot
MeanBalanced data such as test scores or daily temperaturesPulled by extreme values
MedianSkewed data such as incomes and house pricesIgnores how far the other values are spread
ModeMost common choice, such as a popular shoe sizeMay not exist, or may be several values

Here is why it matters. Take six incomes: 38,000, 42,000, 45,000, 47,000, 52,000 and 250,000. The one very high income pulls the mean up to 79,000. The median is only 46,000, which is much closer to what most of the group earns. When the calculator sees the mean and median far apart, it tells you so.

How to Calculate a Weighted Average

A weighted average is used when some values matter more than others:

Weighted average = sum of (value × weight) ÷ sum of the weights

Say your grade is 20% homework (score 90), 30% midterm (score 82) and 50% final exam (score 76):

  • (90 × 20) + (82 × 30) + (76 × 50) = 1,800 + 2,460 + 3,800 = 8,060
  • Weights add up to 100
  • 8,060 ÷ 100 = 80.6

A plain average of the three scores gives 82.67, which ignores that the final counts for half. Weights can be percentages, credit hours or quantities, because the formula divides by their total.

Average in Excel and Google Sheets

If your numbers are in cells A2 to A20, these formulas work in both programs:

  • =AVERAGE(A2:A20) for the mean
  • =MEDIAN(A2:A20) for the median
  • =MODE.SNGL(A2:A20) for the most frequent value, or =MODE.MULT(A2:A20) in Excel to list all modes
  • =STDEV.S(A2:A20) for the sample standard deviation, or =STDEV.P(A2:A20) for a whole population
  • =SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4) for a weighted average, with values in column B and weights in column C

Common Mistakes When Averaging

  • Averaging averages. If class A has 10 students averaging 80 and class B has 30 students averaging 90, the combined average is (800 + 2,700) ÷ 40 = 87.5, not 85. Use the weighted average with the class sizes as weights.
  • Counting blanks as zero. An empty cell is not a score of 0. Leave it out of the list.

Frequently Asked Questions

What is the difference between average and mean?

In everyday language, “average” usually means the mean: the sum divided by the count. Median and mode are also measures of the center, so when a news story says “average income”, check which one it means.

Can a data set have more than one mode?

Yes. If two or more values tie for the highest count, each is a mode. With no repeated value at all, there is no mode.

How do I find the median of an even number of values?

Sort the list, take the two middle values and average them. For 4, 6, 8, 10 the median is (6 + 8) ÷ 2 = 7.

Why is my median different from my mean?

A few very high or very low values pull the mean toward them but barely move the median. The bigger the gap, the more uneven the data usually is.

What is the difference between sample and population standard deviation?

Standard deviation shows how spread out the numbers are. Use the population version (divide by n) when your list is the whole group, and the sample version (divide by n – 1) when it is only a sample. The sample version needs at least two numbers.

Do weights have to add up to 100?

No. The weighted average divides by the total of the weights, so any positive weights work. Percentages, credit hours and quantities are all fine.

This calculator is for general information and learning. Teachers, schools and employers may calculate grades or averages differently, so check the official method before relying on a result.

Scroll to Top