Mean, median, mode and standard deviation
Calculators
Paste numbers separated by anything: spaces, commas, semicolons or new lines.
Runs in your browser
Nothing is uploaded. The work happens on your own device, so your file or text never reaches us.
About this tool
Which standard deviation?
There are two, and spreadsheets offer both without explaining the difference.
Sample standard deviation divides by n − 1. Use it when your numbers are a sample of a larger group you are trying to describe. This is almost always the one you want. (STDEV.S in Excel.)
Population standard deviation divides by n. Use it only when your numbers are the entire group — all twelve months of one year, every employee in the company. (STDEV.P.)
The n − 1 is Bessel’s correction. A sample’s own mean sits closer to its own values than the true mean does, which makes the spread look smaller than it is; dividing by a smaller number compensates. With 5 numbers the two differ by about 12%, with 100 by about 0.5%.
Mean, median, and when they part company
For symmetric data they are close. For skewed data they are not, and the gap is the information.
Income is the standard example: a few very large values pull the mean up while the median stays where most people are. "Average salary" quoted as a mean describes a workforce almost nobody belongs to.
The tool gives both, plus quartiles and the interquartile range, which describe a skewed distribution far better than a mean and a standard deviation can.