Standard Deviation Calculator
Last updated
Show steps
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
- Find the mean: add the values and divide by how many there are.
- Subtract the mean from each value to get its deviation.
- Square each deviation (this removes negative signs).
- Add the squared deviations.
- Divide by N for a population, or by n − 1 for a sample. This is the variance.
- Take the square root of the variance to get the standard deviation.

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
| Measure | Formula | Use |
|---|---|---|
| Variance | s² or σ² | Spread in squared units; used in many statistical tests |
| Standard deviation | √variance | Spread in the original units |
| Standard error of the mean | s ÷ √n | How precisely the sample mean estimates the population mean |
| Coefficient of variation | s ÷ 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
| Function | Calculates |
|---|---|
| =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
- NIST/SEMATECH e-Handbook of Statistical Methods – Measures of scale — itl.nist.gov/div898/handbook/eda/section3/eda356.htm
- OpenStax Introductory Statistics (Rice University) – free textbook — openstax.org/details/books/introductory-statistics-2e
Results are estimates for general information. Last reviewed: .

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
Keep exploring
Related calculators
More calculators people use alongside this one.
- Z-Score CalculatorCalculate a z-score from a value, mean and standard
- Normal Distribution CalculatorFind normal distribution probabilities, z-scores and
- Binomial Distribution CalculatorFind binomial probabilities – exactly k, at most, at
- Dice Average CalculatorFind the average roll for any dice formula such as
Zeeshan Nawaz
Calculator Developer · Tuff Search
Builds and tests Tuff Search calculators. Each tool is based on published formulas and official sources, and is checked against worked test cases before it goes live.
- Standard Deviation CalculatorStatisticsYou are here
- Dog Age CalculatorBiology
- Fuel Cost CalculatorDaily Life