The easiest way to calculate standard deviation
The easiest way to calculate standard deviation is to let a tool do the arithmetic: paste your
numbers into a standard deviation calculator, or type
=STDEV.S(A1:A5) in a spreadsheet. If you have to do it by hand, a three-column
table is the method least likely to go wrong. All four methods below use the same five
numbers, 4, 8, 6, 5, 7, and all give 1.5811.
Which method is easiest for you?
| You have | Easiest method | Time |
|---|---|---|
| A browser | Online calculator | Seconds |
| Data already in a spreadsheet | =STDEV.S( ) or =STDEV.P( ) | Seconds |
| A scientific or graphing calculator (exams) | Statistics mode | About a minute |
| Only pen and paper | Three-column table | A few minutes |
Method 1. An online calculator
Paste 4, 8, 6, 5, 7 into the standard deviation calculator and choose sample or population. It returns s = 1.5811 (sample) or σ = 1.4142 (population), along with the mean, the variance and the working, so you can copy the steps if you need to show them.
Method 2. Excel or Google Sheets
Sample: =STDEV.S(A1:A5) → 1.5811 Population: =STDEV.P(A1:A5) → 1.4142
Put the values in cells A1 to A5 and type one formula. The same two functions work in
Google Sheets. The older =STDEV( ) is the sample version. More detail is in the
guide to standard deviation in Excel.
Method 3. A scientific or graphing calculator
Every scientific calculator with a statistics mode does this for you. Enter the values as a list, then read the result: Sx (or s) is the sample standard deviation and σx is the population one. The key presses differ by model, so see the guides for a Casio or a TI-84. If you are unsure which of the two results to report, Sx vs σx explains the difference.
Method 4. By hand, with a table
The mean is (4 + 8 + 6 + 5 + 7) ÷ 5 = 30 ÷ 5 = 6. Then fill in one row per value.
| Value x | x − mean | (x − mean)² |
|---|---|---|
| 4 | −2 | 4 |
| 8 | 2 | 4 |
| 6 | 0 | 0 |
| 5 | −1 | 1 |
| 7 | 1 | 1 |
| Total | 0 | 10 |
- Add the last column: 10. The middle column should add to 0, which is a quick check on your mean.
- Divide by n − 1 for a sample: 10 ÷ 4 = 2.5. This is the variance.
- Take the square root: √2.5 = 1.5811.
For a whole population, divide by n instead: 10 ÷ 5 = 2, and √2 = 1.4142. The full method, with the reasoning behind each step, is on how to calculate standard deviation.
A shortcut that skips the subtraction
Σ(x − mean)² = Σx² − (Σx)² ÷ n
Square each value and add: Σx² = 190. Square the total and divide by n: 30² ÷ 5 = 180. Subtract: 190 − 180 = 10, the same total as the table. This is quicker when the mean is an awkward decimal, because you never subtract it from anything. The sum of squares calculator shows both routes.
A rough estimate: the range rule of thumb
If you only need to know whether an answer is plausible, divide the range by 4. Here the range is 8 − 4 = 4, so the estimate is 1; the real value is 1.5811. That is close enough to catch an answer of 15 or 0.15, and not close enough to report. The estimate is closest for roughly bell-shaped sets of about 25 to 30 values. For smaller sets like this one it runs low, and for much larger ones it runs high; see estimating the standard deviation from the range.
Mistakes that make it harder than it is
- Forgetting the square root. Stopping at 2.5 gives the variance, not the standard deviation.
- Dividing by n when the data is a sample. Most homework and lab data is a sample, so use n − 1.
- Rounding the mean too early. Keep at least two extra decimals until the final step.
- Squaring the total of the deviations. Square each deviation first, then add. The deviations themselves always add to 0.
Not sure which divisor applies? See sample vs population standard deviation.
Related calculators
-
Standard deviation calculator
Paste a list and get the SD, variance and mean with every step shown.
-
How to calculate standard deviation
The full method, step by step, for sample and population data.
-
Standard deviation in Excel
STDEV.S, STDEV.P and when to use each.
-
Standard deviation on a Casio
The key presses for the fx series.
Common questions
What is the easiest way to calculate standard deviation?
Paste the numbers into a standard deviation calculator or type =STDEV.S(A1:A5) in Excel or Google Sheets. Both take a few seconds and remove the arithmetic slips that cause most wrong answers. By hand, the easiest way is a three-column table: value, deviation from the mean, squared deviation.
What is the easiest way to calculate standard deviation by hand?
Use a table. Find the mean, subtract it from each value, square each result, add the squares, divide by n − 1 (or n for a whole population) and take the square root. For 4, 8, 6, 5, 7 the squares add to 10, so s = √(10 ÷ 4) = 1.5811.
Is there a shortcut formula for standard deviation?
Yes. The sum of squared deviations equals Σx² − (Σx)² ÷ n, so you can skip the subtraction column. For 4, 8, 6, 5, 7: Σx² = 190 and (Σx)² ÷ n = 900 ÷ 5 = 180, which leaves 10, the same total as the table.
Can I estimate standard deviation without calculating it?
Roughly. The range rule of thumb says SD ≈ range ÷ 4. It is a sanity check, not an answer: for 4, 8, 6, 5, 7 it gives 4 ÷ 4 = 1, while the real sample SD is 1.5811. It is closest for bell-shaped sets of about 25 to 30 values and runs low on small sets like this one.
Should I divide by n or n − 1?
Divide by n − 1 when your numbers are a sample from a larger group, which is the usual case. Divide by n only when the list is the entire population. Excel's STDEV.S and a calculator's Sx use n − 1; STDEV.P and σx use n.