Maaz Zindani

Loading the index…

↑↓ move↵ openesc close3993 pages

Free tool · Math and study

Average calculator

Paste a list of numbers to get the mean, median, mode, range, sum and count, or switch to a weighted average. Every step is shown with your own numbers.

  • Free
  • No sign-up
  • Runs in your browser

By Maaz Zindani · Updated

What do you want to find?
Paste from a spreadsheet or type them: commas, spaces or new lines all work. Use a dot for decimals. Words and blank cells are skipped; zeros count. With decimal commas (3,5), separate the numbers with semicolons.
More averages
Mean (average)

16.6667100 ÷ 6, rounded to 4 decimal places

  • 6 numbers read
  • One mode
  • Even count
Median
15
Mode
15
Range
22
Sum
100
Count
6
Smallest
8
Largest
30

Steps

  1. Mean. Add all 6 numbers: 12 + 15 + 15 + 20 + 8 + 30 = 100. Divide the sum by the count: 100 ÷ 6 ≈ 16.6667.
  2. Median. Sort the numbers from smallest to largest: 8, 12, 15, 15, 20, 30. There are 6 (an even count), so the median is the average of the 3rd and 4th numbers: (15 + 15) ÷ 2 = 15.
  3. Mode. Count how often each value appears. 15 appears 2 times, more than any other value, so it is the mode.
  4. Range. Largest minus smallest: 30 − 8 = 22.

How to use the Average Calculator

  1. Choose Average of a list or Weighted average.
  2. Paste or type Your numbers, separated by commas, spaces or new lines. For a weighted average, type one value, weight pair per line.
  3. Pick how many decimal places to Round answers to, and tick Geometric and harmonic mean if you want those too.
  4. Read the mean under Result, with the median, mode, range, sum and count, then follow the numbered Steps or press Copy results.

How do I calculate the average of a list of numbers?

The average most people mean is the arithmetic mean: add all the numbers and divide by how many there are, mean = sum ÷ count. The tool opens on 12, 15, 15, 20, 8 and 30. They add up to 100 and there are 6 of them, so the mean is 100 ÷ 6 = 16.6667. The 6 repeats forever, so the answer is rounded; you can choose anywhere from whole numbers to 10 decimal places. The sum and the division are done in exact decimal arithmetic, so 0.1 and 0.2 average to exactly 0.15 and not to a long floating-point tail.

You can paste a column straight from a spreadsheet, or type the numbers: commas, spaces, tabs and new lines all separate them. Write decimals with a dot. If your numbers use decimal commas such as 3,5, separate them with semicolons and the commas are read as decimal points. A thousands separator is not understood: type 1200, because 1,200 is read as the two numbers 1 and 200.

What is the difference between mean, median and mode?

The mean is the sum divided by the count. The median is the middle value once the numbers are sorted. With an odd count it is the middle number, and with an even count it is the average of the two middle numbers: for 8, 12, 15, 15, 20, 30 the 3rd and 4th numbers are both 15, so the median is 15. The mode is the value that appears most often, here 15, which appears twice. The range is the largest minus the smallest: 30 − 8 = 22.

A list can have more than one mode (1, 1, 2, 2, 3 has two) or none at all, when every value appears once. The tool says so instead of printing a made-up value. The mean uses every number, so one extreme value pulls it: change the 30 to 300 and the mean jumps to 61.6667 while the median stays 15. That is why prices and incomes are often quoted as medians.

The optional geometric mean multiplies the numbers and takes the root that matches the count. It suits growth factors. The harmonic mean divides the count by the sum of the reciprocals and suits rates: driving the same distance at 40 and at 60 km/h averages 48 km/h, not 50. Both need every number to be above 0, and the page says so when they cannot be worked out.

How do I calculate a weighted average, and how do I find the average of percentages?

In a weighted average some values count more than others. Multiply each value by its weight, add those products, and divide by the sum of the weights. With 90 at weight 30, 80 at weight 50 and 70 at weight 20 you get (2700 + 4000 + 1400) ÷ 100 = 81, while the plain average of the three values is 80. A weight can be points, credits, hours or a percent, and the weights do not have to add up to 100, because the tool divides by their total. A weight of 0 leaves that value out, and negative weights are refused.

Percentages can be averaged directly only when every percentage is out of the same base. If one is 80% of 50 students and another is 60% of 150 students, the plain average of 70% is wrong: weight each percentage by its group size instead. Enter 80, 50 and 60, 150 and the answer is (4000 + 9000) ÷ 200 = 65%.

How do I find the average if there are blank cells or zeros?

Blank cells and words, such as a column heading, are skipped, and the result lists what was skipped so you can check that nothing was lost. A zero is a real value and is counted: 80, 90 and 0 average 56.6667, while 80 and 90 alone average 85. If a zero in your sheet only means "no data", delete it before you calculate. The count shown in the chip tells you how many numbers were read.

Use it with

Questions

How do I calculate the average of a list of numbers?

Add the numbers and divide the sum by how many there are. For 12, 15, 15, 20, 8 and 30 the sum is 100 and the count is 6, so the mean is 100 ÷ 6 = 16.6667.

What is the difference between mean, median and mode?

The mean is the sum divided by the count, the median is the middle value of the sorted list, and the mode is the value that appears most often. The mean is pulled by extreme values; the median is not.

How do I find the average of percentages?

If the percentages are out of the same total, average them directly. If the groups differ in size, weight each percentage by its group size: 80% of 50 and 60% of 150 give (80 × 50 + 60 × 150) ÷ 200 = 65%.

How do I calculate a weighted average?

Multiply each value by its weight, add the products and divide by the sum of the weights. 90 at 30, 80 at 50 and 70 at 20 give 8100 ÷ 100 = 81.

How do I find the average if there are blank cells or zeros?

Blank cells are skipped, so they do not change the count. Zeros are counted as real values. Delete a zero first if it only means that nothing was recorded.

How this page was made: the tool's results are computed in your browser by the code on this page; the explanations were drafted with AI help and checked against the tool's own output.