This calculator gives the sample and population standard deviation and variance side by side, so you never have to guess which one your teacher or software expects. It also builds the full table of deviations and shows each step of the working.
Sample vs population standard deviation
The only difference is the divisor. The population formula divides the sum of squared deviations by n; the sample formula divides by n − 1. Dividing by n − 1 (Bessel’s correction) corrects the tendency of a sample to underestimate the spread of the population it came from.
Sample: s = √[ Σ(x − x̄)² ÷ (n − 1) ] · Population: σ = √[ Σ(x − μ)² ÷ n ]
| Use | When | Excel |
|---|---|---|
| Sample SD (s) | Your data are a sample from a larger population, as in surveys, experiments and most coursework | STDEV.S |
| Population SD (σ) | You have every member of the population, e.g. all employees of one company | STDEV.P |
How to calculate standard deviation by hand
- Find the mean of the data.
- Subtract the mean from each value to get its deviation.
- Square each deviation and add them up. This is the sum of squares, SS.
- Divide SS by n − 1 for a sample (or n for a population) to get the variance.
- Take the square root of the variance.
Worked example
For 2, 4, 4, 4, 5, 5, 7, 9 the mean is 5 and the sum of squared deviations is 32. The population variance is 32 ÷ 8 = 4, so σ = 2. The sample variance is 32 ÷ 7 = 4.571, so s = 2.138. The calculator shows both and the table of deviations behind them.
Frequently asked questions
What is a “good” standard deviation?
There isn’t one. The SD is in the same units as your data, so it only means something relative to the mean and the context. To compare variability across datasets with different units or scales, use the coefficient of variation in the descriptive statistics calculator.
Can the standard deviation be negative?
No. It is the square root of an average of squared numbers, so it is always zero or positive. It is zero only when every value is identical.
What is the difference between standard deviation and standard error?
The standard deviation describes how spread out individual values are. The standard error (SD ÷ √n) describes how precisely the sample mean estimates the population mean, and it shrinks as the sample grows.