📏 Standard Deviation Calculator
Paste your numbers — get the sample and population standard deviation, variance, mean, median and quartiles, with every step shown.
Standard deviation formulas
Sample: s = √[ Σ(x − x̄)² ÷ (n − 1) ] · Population: σ = √[ Σ(x − μ)² ÷ N ]
- Find the mean: add the values and divide by how many there are.
- Subtract the mean from each value (the deviations) and square each result.
- Add the squares — this is the sum of squares (SS).
- Divide SS by n − 1 for a sample (or by N for a population). That is the variance.
- Take the square root. That is the standard deviation.
Worked example
Eight quiz scores: 12, 15, 11, 18, 14, 16, 13, 17.
| Step | Work | Result |
|---|---|---|
| Mean | 116 ÷ 8 | 14.5 |
| Squared deviations | 6.25, 0.25, 12.25, 12.25, 0.25, 2.25, 2.25, 6.25 | SS = 42 |
| Sample variance | 42 ÷ 7 | s² = 6 |
| Sample SD | √6 | s ≈ 2.449 |
| Population SD | √(42 ÷ 8) = √5.25 | σ ≈ 2.291 |
Press “Try an example” above to see the same numbers worked out in the calculator. The idea behind each step is explained in the free lesson Spread: range, IQR and standard deviation.
In Excel, Google Sheets and on a TI-84
- Sample SD:
=STDEV.S(A1:A20)(older:=STDEV) · population SD:=STDEV.P(A1:A20) - Variance:
=VAR.Sand=VAR.P· mean:=AVERAGE· median:=MEDIAN - TI-83/84: enter the data in L1, then STAT → CALC → 1-Var Stats. Sx is the sample SD, σx the population SD.
Next: turn a value into a z-score with the z-score calculator, or build an interval with the confidence interval calculator.
Questions and answers
Should I use the sample or the population standard deviation?
Use the sample SD (divide by n − 1) when your numbers are a sample from a bigger group you want to describe — survey answers, lab measurements, test scores of one class used to learn about all students. That is almost always the case in coursework and research. Use the population SD (divide by N) only when you have every member of the group, such as the final grades of all 30 students in your own class and you only care about that class.
Why divide by n − 1 for a sample?
A sample’s values sit closer to their own mean than to the true population mean, so dividing by n would underestimate the spread. Dividing by n − 1 (Bessel’s correction) makes the sample variance an unbiased estimate of the population variance.
What is the difference between variance and standard deviation?
Variance is the average squared distance from the mean; standard deviation is its square root. SD is in the same units as your data (points, cm, dollars), so it is the one you report and interpret.
What is a “good” or “high” standard deviation?
It depends on the scale. Compare it with the mean using the coefficient of variation (SD ÷ mean): a CV under about 10% means the values are tightly clustered, over 30% means they vary a lot. For roughly bell-shaped data, about 68% of values fall within 1 SD of the mean and 95% within 2 SD.
How are the quartiles calculated?
Q1 is the median of the lower half and Q3 the median of the upper half; when n is odd, the middle value is left out of both halves. This is the method used by the TI-84 and most intro statistics textbooks. Excel’s QUARTILE.EXC and QUARTILE.INC interpolate, so they can differ slightly.
Can I paste data from Excel or Google Sheets?
Yes. Copy a column (or a row) and paste it into the box — values on separate lines, or separated by commas, spaces or tabs, all work. Use a dot for decimals.