Skip to content

Standard Deviation Calculator

Last updated

Your data

Paste or type numbers separated by commas, spaces or new lines.

Data

Data type

Results update as you type

—

Paste or type your numbers and this standard deviation calculator gives the sample and population standard deviation, variance, mean, standard error and coefficient of variation, with a step-by-step table showing how each value was found.

How to calculate standard deviation step by step

  1. Find the mean: add the values and divide by how many there are.
  2. Subtract the mean from each value to get its deviation.
  3. Square each deviation (this removes negative signs).
  4. Add the squared deviations.
  5. Divide by N for a population, or by n − 1 for a sample. This is the variance.
  6. Take the square root of the variance to get the standard deviation.
Step-by-step standard deviation table for the data 2, 4, 4, 4, 5, 5, 7, 9 showing deviations from the mean of 5, squared deviations summing to 32, population standard deviation 2 and sample 2.138
Every squared deviation adds to the variance.

For 2, 4, 4, 4, 5, 5, 7, 9: the mean is 40 ÷ 8 = 5. The squared deviations add to 32. As a population, variance = 32 ÷ 8 = 4 and σ = 2. As a sample, variance = 32 ÷ 7 = 4.571 and s = 2.138.

Sample or population standard deviation?

Use the population formula when your data includes every member of the group you care about – all students in one class, every transaction in a month. Use the sample formula when your data is a subset used to estimate a larger group – 50 customers surveyed out of thousands. Dividing by n − 1 (Bessel's correction) makes the sample variance an unbiased estimate of the population variance, because a sample's values tend to sit a little closer to their own mean than to the true population mean. With large samples the two results are almost identical.

What standard deviation tells you

A small standard deviation means values cluster near the mean; a large one means they are spread out. Exam scores 72, 85, 90, 64, 78, 88, 95, 70 have a mean of 80.25 and a sample SD of 10.94 points. If data is roughly bell-shaped (normal), the 68-95-99.7 rule applies:

  • About 68% of values fall within 1 standard deviation of the mean.
  • About 95% fall within 2 standard deviations.
  • About 99.7% fall within 3 standard deviations.

So for normally distributed scores with mean 80 and SD 10, roughly 95% of students would score between 60 and 100. To see where a single value sits, convert it to a z-score with the z-score calculator, or explore probabilities with the normal distribution calculator.

Variance, standard error and coefficient of variation

MeasureFormulaUse
Variances² or σ²Spread in squared units; used in many statistical tests
Standard deviation√varianceSpread in the original units
Standard error of the means ÷ √nHow precisely the sample mean estimates the population mean
Coefficient of variations ÷ mean × 100%Compare spread across data with different units or scales

For the exam scores, the standard error is 10.94 ÷ √8 = 3.87 and the coefficient of variation is 13.6%.

Standard deviation in Excel and Google Sheets

FunctionCalculates
=STDEV.S(range)Sample standard deviation (n − 1)
=STDEV.P(range)Population standard deviation (N)
=VAR.S(range) / =VAR.P(range)Sample / population variance
=AVERAGE(range)Mean

Older spreadsheets use STDEV (sample) and STDEVP (population). Google Sheets supports the same names.

Outliers and other cautions

  • Because deviations are squared, one extreme value can inflate the standard deviation a lot. Check outliers before reporting.
  • For skewed data (incomes, house prices), the median and interquartile range often describe the data better.
  • Standard deviation cannot be negative; it is zero only when every value is the same.
  • Mixing units (cm and inches) in one data set makes the result meaningless.

Comparing two data sets

Two classes both average 75 on a test. Class A's scores have a standard deviation of 4; Class B's have 15. Class A's results are tightly grouped – most students scored between about 67 and 83. Class B is much more spread out, with some very high and very low scores. The mean alone would hide this difference, which is why reports usually give the mean and the standard deviation together.

Standard deviation of grouped data

When data comes in a frequency table, multiply each value (or class midpoint) by its frequency. Mean = Σ(f × x) ÷ Σf. Variance = Σ f(x − mean)² ÷ (Σf − 1) for a sample. Example: values 1, 2 and 3 with frequencies 2, 5 and 3 – mean = (2 + 10 + 9) ÷ 10 = 2.1. The calculator accepts 'value×frequency' pairs so you do not have to type each value out.

Standard deviation in finance and quality control

In investing, the standard deviation of returns is a common measure of volatility: a fund whose yearly returns vary widely around their average is considered riskier. In manufacturing, standard deviation tracks how consistent a process is – Six Sigma programmes aim for processes so consistent that defects are extremely rare.

Sources

  1. NIST/SEMATECH e-Handbook of Statistical Methods – Measures of scale — itl.nist.gov/div898/handbook/eda/section3/eda356.htm
  2. OpenStax Introductory Statistics (Rice University) – free textbook — openstax.org/details/books/introductory-statistics-2e

Results are estimates for general information. Last reviewed: .

Zeeshan Nawaz

Written & built by

Zeeshan Nawaz

Calculator Developer · Tuff Search

Builds and tests Tuff Search calculators, turning published formulas and official sources into tools anyone can check.

FAQ

Frequently asked questions

Quick answers about the Standard Deviation Calculator.

The typical distance of the values from their average.

When your data is a sample used to estimate a larger population.

There is no universal good value – it depends on the data. Compare it with the mean (coefficient of variation) or with other groups.

Variance is the average squared deviation; standard deviation is its square root, in the original units.

Yes, especially for data with many small values and a few large ones.

Use =STDEV.S for a sample or =STDEV.P for a whole population.

Still have a question? Email support@tuffsearch.com