How to find standard deviation

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:

Handwritten statistics notes with formulas and a table on lined paper
Statistics notes written by hand, with formulas and a table a standard deviation problem uses.Photo: MiraCosic / Pixabay
  1. 1

    The mean

    Add the values and divide by how many there are.

  2. 2

    The deviations

    Subtract the mean from each value.

  3. 3

    The variance

    Square the deviations, add them, divide by n − 1.

  4. 4

    The square root

    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.

Keep your formulas in Evernote

How to find standard deviation in 6 steps

  1. 1

    Find the mean

    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.

  2. 2

    Subtract the mean from each value

    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.

  3. 3

    Square each deviation

    Squaring makes every deviation positive, so values below the mean do not cancel out those above it.

  4. 4

    Add the squares

    This total, Σ(x − x̄)², is called the sum of squares.

  5. 5

    Divide to get the variance

    For a sample, divide by n − 1. For a whole population, divide by N, the number of values. The result is the variance.

  6. 6

    Take the square root

    The square root of the variance is the standard deviation. It brings the spread back to the units of the data.

Standard deviation example

Five quiz scores, treated as a sample

Find the sample standard deviation of 6, 8, 10, 12, 14.

2
xx − x̄(x − x̄)²
6−416
8−24
1000
1224
14416
Σx = 50Σ = 0Σ = 40
  1. 1Meanx̄ = 50 ÷ 5 = 10
  2. 3Squares16 + 4 + 0 + 4 + 16
  3. 4Sum of squaresΣ(x − x̄)² = 40
  4. 5Variances² = 40 ÷ (5 − 1) = 40 ÷ 4 = 10
  5. 6Standard deviations = √10 ≈ 3.162

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.

Sample vs population standard deviation

Use the sample formula when your data is part of a larger group you want to describe.

SamplePopulation
Symbolsσ (sigma)
Formulas = √(Σ(x − x̄)² ÷ (n − 1))σ = √(Σ(x − μ)² ÷ N)
Divide byn − 1N, the number of values
Use it whenYour data is a sample from a bigger groupYou have every member of the group
ExcelSTDEV.SSTDEV.P
Google SheetsSTDEVSTDEVP

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).

Trusted by Millions Worldwide

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

Standard deviation questions

What does standard deviation tell you?

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.

What is the formula for standard deviation?

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.

Why divide by n − 1 for a sample?

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.

What is the difference between variance and standard deviation?

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.

Can standard deviation be negative?

No. It is always positive or zero. It is zero only when every value is the same.

How do I calculate standard deviation in Excel or Google Sheets?

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.

What is a high standard deviation?

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.

How does an outlier affect standard deviation?

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.

How do I find a value that is one standard deviation above the mean?

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.

How to keep your statistics formulas with Evernote

Keep a Math notebook with your statistics formula sheet and a note for each problem you photograph.

  1. 1

    Build a formula sheet.

    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.

  2. 2

    Explain a problem.

    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.

  3. 3

    Practice before the test.

    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.

  • You can also search for a word in your photographed worksheets and find the page.
  • You can also draw a graph by hand in a sketch block.
  • You can also ask the AI Assistant to write practice problems from your notes, with answers.

Keep every formula and worked example in one place

Build a formula sheet, photograph a problem for a step-by-step explanation, and practice on a schedule before the test.

Start for free