Open Calculator

Average Calculator

Mean, median, mode, and standard deviation of a list of numbers.

Excel: the button above exports this calculation as a spreadsheet with live formulas, or download the blank template.

How the average calculator works

"Average" usually means the arithmetic mean, but the median and mode are averages too, and each answers a different question about a list of numbers. This calculator reports all three along with the sum, count, minimum, maximum, range, and standard deviation, so you can see the center of the data and how spread out it is.

mean   = sum of values / count
median = middle value of the sorted list (mean of the two middle values if the count is even)
mode   = most frequent value(s)
range  = maximum - minimum

Worked example

The default list is 2, 4, 4, 4, 5, 5, 7, 9: eight numbers that sum to 40.

mean   = 40 / 8 = 5
median = sorted list is already 2 4 4 4 | 5 5 7 9, middle pair is 4 and 5, so (4 + 5) / 2 = 4.5
mode   = 4 (appears three times)
range  = 9 - 2 = 7

Standard deviation

Standard deviation measures how far values typically sit from the mean. Subtract the mean from each value, square the differences, average the squares (that average is the variance), and take the square root. The only choice is what to divide by: n for a population, n - 1 for a sample, which slightly inflates the estimate to correct for the fact that a sample tends to underestimate spread.

deviations from 5:  -3, -1, -1, -1, 0, 0, 2, 4
squared:             9,  1,  1,  1, 0, 0, 4, 16   (sum 32)
population variance = 32 / 8 = 4        -> standard deviation = 2
sample variance     = 32 / 7 = 4.5714   -> standard deviation = 2.1381

The population figures are what a textbook exercise wants when it gives you "the data". The sample figures are what a survey or experiment wants. Spreadsheets follow the same split: STDEV.P and STDEV.S.

Which average to use

MeasureBest whenWatch out for
MeanValues are roughly symmetric with no extreme outliers; you need a total (mean x count = sum)A single huge value drags it toward the tail
MedianData is skewed (incomes, prices, wait times) or has outliersIgnores the actual size of extreme values
ModeData is categorical or you want the most common value (shoe sizes, survey answers)May not exist, or there may be several

Mean of a skewed list

Consider five salaries: 40,000, 45,000, 50,000, 55,000, and 400,000. The mean is 118,000, which is higher than four of the five values; the median is 50,000, which describes the typical person. The mode does not exist. Whenever the mean and median differ a lot, the data is skewed and the median is usually the more honest summary.

Tips for entering data

Frequently asked questions

What is the difference between mean, median, and mode?

The mean is the sum divided by the count. The median is the middle value when the numbers are sorted (or the average of the two middle values). The mode is the value that appears most often; a list can have several modes or none.

When should I use the median instead of the mean?

When a few extreme values would distort the mean. Household income, house prices, and response times are usually reported as medians because one very large value can pull the mean far above what is typical.

Population or sample standard deviation: which one do I want?

Use population (divide by n) when your numbers are the entire group you care about, such as every student's score in one class. Use sample (divide by n - 1) when the numbers are a sample drawn from a larger group and you want to estimate that group's spread.

What separators can I use when pasting numbers?

Commas, spaces, semicolons, tabs, and new lines all work, in any combination, so you can paste a column from a spreadsheet directly. Dollar and percent signs are stripped.

How do I average percentages or grades with different weights?

A plain average treats every value equally. If some values should count more, use the grade calculator's weighted mode, which multiplies each value by its weight before averaging.

Related calculators