Paste a list of numbers — commas, spaces or a whole spreadsheet column — and get the mean, median, mode and range together, so you can see when they disagree.
Separate with commas, spaces or new lines. You can paste a column straight out of Excel or Google Sheets.
Mean (average)
—
Median—
Mode—
Count—
Sum—
Minimum—
Maximum—
Range—
Geometric mean—
—
Embed this calculator on your site — free
Advertisement
Ad slot A
Mean, median and mode — what each one tells you
The mean is the total divided by how many numbers you have. It uses every single value, which makes it precise but also fragile: one extreme number drags it a long way from the centre.
The median is the middle value once the list is sorted. Half the data sits above it, half below. Because it only cares about position and not distance, it survives outliers intact — which is why house prices and salaries are almost always quoted as medians.
The mode is the value that appears most often. It is the only average that works on categories rather than numbers, and the only one that can be missing entirely (nothing repeats) or ambiguous (several values tie).
When they disagree
Data set
Mean
Median
What happened
4, 5, 6, 7, 8
6.0
6
Symmetric — they agree
4, 5, 6, 7, 200
44.4
6
One outlier wrecks the mean
1, 1, 1, 9, 9
4.2
1
Two clusters, no real centre
If the mean and the median are far apart, your data is skewed and neither number alone describes it honestly — quote both, and check the standard deviation to see how wide the spread really is.
Use the mean for roughly symmetric data where every value should count — test scores, repeated measurements, daily temperatures. Use the median whenever a handful of extreme values could distort the picture — incomes, property prices, page load times, waiting times. Use the mode for categories and for questions about the most common outcome, like which shoe size to stock most of.
The geometric mean
The geometric mean multiplies every value together and takes the nth root. It is the correct average for things that compound — growth rates, investment returns, year-on-year ratios. Averaging +50% and −50% the ordinary way gives 0%, but you are actually down 25%; the geometric mean gets that right. It needs every value to be positive, so it shows as unavailable if your list contains a zero or a negative number.
Add all the numbers together, then divide by how many numbers there are. For 12, 15 and 9: 12 + 15 + 9 = 36, and 36 ÷ 3 = 12. That result is the mean, which is what people normally mean by 'the average'.
What is the difference between mean, median and mode?
The mean is the total divided by the count. The median is the middle value after sorting. The mode is the value that occurs most often. On symmetric data all three land close together; on skewed data they can be far apart, which is itself useful information.
Can I paste numbers from Excel or Google Sheets?
Yes. Copy a column and paste it straight into the box. Line breaks, commas, semicolons, tabs and spaces are all treated as separators, and anything that is not a number is ignored.
Why does the mode say 'none'?
Because no value repeats. A mode only exists when at least one number appears more than once. If several values tie for the most appearances, the data is multimodal and all the tied values are shown.
How is the median found with an even number of values?
There is no single middle value, so the two middle values are averaged. For 4, 6, 8, 10 the two middle numbers are 6 and 8, giving a median of 7.