4.4
2,100+ reviews on G2
Standard deviation is a number that measures how far data values are from their mean, in the same units as the data. To find it by hand, you work through four quantities:

Add the values and divide by how many there are.
Subtract the mean from each value.
Square the deviations, add them, divide by n − 1.
The root of the variance is the standard deviation.
Do your homework in Evernote. The AI Assistant explains any problem you photograph, step by step.
Add all the values and divide by how many there are (n). For 6, 8, 10, 12 and 14, the sum is 50 and n is 5, so the mean x̄ is 10.
Each result is a deviation: how far that value is from the mean. Negative deviations are below the mean. Together they always add up to zero.
Squaring makes every deviation positive, so values below the mean do not cancel out those above it.
This total, Σ(x − x̄)², is called the sum of squares.
For a sample, divide by n − 1. For a whole population, divide by N, the number of values. The result is the variance.
The square root of the variance is the standard deviation. It brings the spread back to the units of the data.
Find the sample standard deviation of 6, 8, 10, 12, 14.
| x | x − x̄ | (x − x̄)² |
|---|---|---|
| 6 | −4 | 16 |
| 8 | −2 | 4 |
| 10 | 0 | 0 |
| 12 | 2 | 4 |
| 14 | 4 | 16 |
| Σx = 50 | Σ = 0 | Σ = 40 |
s ≈ 3.16, rounded to the nearest hundredth
If these five scores were the whole population, you would divide by 5 instead: σ² = 40 ÷ 5 = 8, so σ = √8 ≈ 2.83.
Use the sample formula when your data is part of a larger group you want to describe.
| Sample | Population | |
|---|---|---|
| Symbol | s | σ (sigma) |
| Formula | s = √(Σ(x − x̄)² ÷ (n − 1)) | σ = √(Σ(x − μ)² ÷ N) |
| Divide by | n − 1 | N, the number of values |
| Use it when | Your data is a sample from a bigger group | You have every member of the group |
| Excel | STDEV.S | STDEV.P |
| Google Sheets | STDEV | STDEVP |
OpenStax Introductory Statistics 2e, section 2.7; NIST/SEMATECH e-Handbook of Statistical Methods, "Measures of Scale"; Microsoft Support (STDEV.S); Google Docs Editors Help (STDEV).
4.4
2,100+ reviews on G2
4.4
8,200+ reviews on Capterra
4.4
73,000+ reviews on App Store
248M
Registered users
How spread out the values are around the mean. A small standard deviation means the values sit close to the mean; a large one means they are spread far from it.
For a sample: s = √(Σ(x − x̄)² ÷ (n − 1)). For a population: σ = √(Σ(x − μ)² ÷ N). x̄ and μ are the means, n and N the number of values.
The sample variance is an estimate of the population variance, and dividing by n − 1 instead of n gives a better estimate of it. Calculators and spreadsheets call this the "n − 1" method.
The variance is the average of the squared deviations, so its units are squared. The standard deviation is its square root, which puts the spread back in the units of the data.
No. It is always positive or zero. It is zero only when every value is the same.
In Excel, type =STDEV.S(A1:A5) for a sample or =STDEV.P(A1:A5) for a population. In Google Sheets, use =STDEV(A1:A5) for a sample or =STDEVP(A1:A5) for a population.
There is no universal cutoff: it depends on the units and the mean. Use it to judge single values instead. As a rule of thumb, a value more than about two standard deviations from the mean is far from it.
It can raise it a lot. Squaring the deviations gives extra weight to values far from the mean, so one extreme value can inflate the standard deviation.
Add one standard deviation to the mean. With a mean wait of 5 minutes and a standard deviation of 2, a 7-minute wait is one standard deviation above the mean.
Keep a Math notebook with your statistics formula sheet and a note for each problem you photograph.
Ask the AI Assistant to add the sample standard deviation formula to your statistics formula sheet, with one worked example. It writes the formula in a formula block, so it reads like the textbook.
Add a photo of your statistics problem, such as the five quiz scores, and ask the Assistant to explain it step by step. It reads the photo and adds the steps under it.
Ask the Assistant for a repeating practice task, such as 10 standard deviation problems every Tuesday and Thursday until the test. You get a reminder each time.
Build a formula sheet, photograph a problem for a step-by-step explanation, and practice on a schedule before the test.
Start for free