Average Calculator

Find the mean, median, mode and range of any list of numbers, or a weighted average

100% free. Runs entirely in your browser - your files and data never leave your device and nothing is uploaded to any server.

Numbers

7 numbers found. Anything that is not a number is ignored, so you can paste a column from a spreadsheet.

Average (mean)

86.285714

sum 604 ÷ 7 numbers

Median
88
Mode
None
Range
19
Smallest
76
Largest
95
Count
7
Std dev (population)
6.562105
Std dev (sample)
7.087884
Geometric mean
86.030404
Harmonic mean
85.76987
Show the working

Mean = (85 + 92 + 78 + 90 + 88 + 76 + 95) ÷ 7 = 604 ÷ 7 = 86.285714

Sorted: 76, 78, 85, 88, 90, 92, 95

Median: the middle value of 7 numbers is 88

Find the average of any list of numbers

The average most people mean is the mean: add the numbers and divide by how many there are. This calculator gives you that instantly for any list - typed, or pasted straight from a spreadsheet column - along with the median (the middle value), the mode (the most common value), the range, the smallest and largest numbers, and both kinds of standard deviation. Positive data also gets the geometric and harmonic means. A second tab works out a weighted average, where some values count more than others, such as marks weighted by credit hours or prices weighted by quantity. The working is shown so you can copy it into homework.

How to use this tool

  1. Enter your numbersSeparate them with commas, spaces or new lines - or paste a column from Excel or Google Sheets.
  2. Read the averageThe mean appears at the top, with the sum and count used to get it.
  3. Check the other measuresMedian, mode, range, standard deviation and more are listed below.
  4. Use Weighted average when values count differentlyEnter each value with its weight - credits, quantities or percentages.

Mean, median and mode - which average should you use?

The mean uses every value, so it is the best all-round average for data without extreme values. For 2, 4, 4, 4, 5, 5, 7 and 9, the mean is 40 ÷ 8 = 5.

The median is the middle value once the numbers are sorted (4.5 here), and it ignores how extreme the ends are. The mode is the value that appears most often (4 here); a list where every value appears once has no mode.

Key features

  • Paste messy data - anything that is not a number is ignored.
  • Mean, median, mode, range, min, max and both standard deviations at once.
  • Weighted average with the formula shown.
  • Step-by-step working for the mean and median.

Common uses

  • Average marks for a class or across subjects.
  • Average prices, sales or expenses.
  • Weighted grades by credit hours.
  • Quick statistics for a survey or experiment.

Tips for better results

  • Use the median when a few very large or small values would distort the mean - house prices and salaries are classic examples.
  • Use sample standard deviation for data that is a sample of a bigger group, and population when you have every value.
  • Weights do not need to add up to 100; they are scaled automatically.

Mistakes to avoid

  • Averaging percentages from groups of different sizes without weighting them.
  • Leaving a total row in pasted spreadsheet data, which counts as an extra number.

Frequently asked questions

Add all the numbers and divide by how many numbers there are. For 85, 92 and 78 the average is 255 ÷ 3 = 85.

An average in which some values count more. Multiply each value by its weight, add the results, and divide by the total weight.

The mean is the arithmetic average of all values; the median is the middle value. The median is less affected by extreme values.

When every value appears the same number of times, there is no mode, and the calculator says None.

Population if your list contains every value in the group, sample if it is a sample from a bigger group.

Yes. Paste a column or row - numbers are picked out automatically.

No. Calculations happen in your browser.