Standard Deviation Calculator: Sample and Population

Enter up to 10 values and how many of them to use. You get sample and population standard deviation, variance and the mean.

Sample vs population standard deviation

Standard deviation measures how spread out numbers are around their mean. The population version divides the sum of squared deviations by n. The sample version divides by n – 1, which corrects for the fact that a sample tends to understate the spread of the whole group.

Sample s = square root of [ sum of (x – mean)^2 / (n – 1) ]

Steps

1. Find the mean. 2. Subtract the mean from each value and square the result. 3. Add the squares. 4. Divide by n – 1 for a sample or n for a population. 5. Take the square root.

Worked example

Data: 4, 8, 6, 5, 3, 7, 9, 5. The mean is 47 / 8 = 5.875. The squared deviations add up to 28.875. Sample variance = 28.875 / 7 = 4.125, so s = 2.031. Population variance = 28.875 / 8 = 3.609, so the population standard deviation = 1.900.

Excel functions

Use =STDEV.S(A2:A9) for a sample and =STDEV.P(A2:A9) for a population. Variance uses =VAR.S and =VAR.P. The mean is =AVERAGE.

How to read the result

A small standard deviation means values sit close to the mean. A large one means they are widely spread. It is in the same units as your data, which makes it easier to interpret than variance.

Frequently asked questions

Which standard deviation should I use?

Use the sample version if your numbers are a sample of a bigger group, which is the usual case. Use the population version only when you have every member of the group.

What is the difference between variance and standard deviation?

Standard deviation is the square root of variance, so it is in the same units as the data.

Can standard deviation be negative?

No. It is a square root of a sum of squares, so it is zero or positive.

What does a standard deviation of 0 mean?

Every value in the data set is identical.

Average calculator · Percent error calculator · Percentage formula in Excel · All free calculators · How to Calculate Standard Deviation · How to Calculate a Z-Score in Excel · How to Calculate Percent Difference

Estimates only. Results depend on the numbers you enter and are not financial, tax or legal advice.