Skip to content
SUMILORASUMILORA

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.

Questions

What is the difference between mean and average?

In everyday use they are the same word. "Average" can also loosely mean the median or mode, which is why statistics prefers the specific terms.

Should I use STDEV.S or STDEV.P?

STDEV.S (sample, n−1) unless your data is the complete population. The sample version is the right default.

What if no number repeats?

Then there is no mode, and the tool says so rather than returning an arbitrary value. If several values tie for most frequent, all of them are listed.

Related tools