Standard Deviation Calculator
Paste a list of numbers and the calculator returns the mean, variance, standard deviation (both sample s with n−1 denominator and population σ with n denominator), the coefficient of variation, and z-scores for each value. Handy when you want to know how dispersed your data is around its average — a key diagnostic before running any parametric test.
How standard deviation is computed
-
1
Paste your numbers
Separated by commas, spaces or newlines. Non-numeric entries are skipped.
-
2
Mean x-bar is computed
Sum divided by count.
-
3
Squared deviations are summed
sum((x − x-bar)²).
-
4
Divide and take the root
Sample: divide by (n−1), take √. Population: divide by n, take √.
Sample vs population — when to use which
| Use population (n divisor) | Use sample (n−1 divisor) |
|---|---|
| You have the entire population | You have a sample drawn from a larger population |
| Full census of employees | 20 customers sampled from thousands |
| All 10 rolls of a die in a specific session | Measurements from a production line |
The n−1 divisor (Bessel’s correction) produces an unbiased estimator of the population variance from sample data. With n as divisor you systematically underestimate the true population variance. For large n the difference shrinks but it matters at small sample sizes.
Standard deviation intuition
If a set has mean 100 and SD 15, then (assuming roughly normal distribution):
- 68% of values fall within 85-115 (1 SD)
- 95% within 70-130 (2 SD)
- 99.7% within 55-145 (3 SD)
That is the 68-95-99.7 rule, also called the empirical rule. IQ scores, human heights, and many natural measurements follow it closely.
Coefficient of variation
CV = SD / mean. A unitless measure of dispersion — useful when comparing variability across datasets with different means. A CV of 0.1 (10%) means the SD is 10% of the mean, roughly. Not meaningful for data that can cross zero.
Z-scores
For each value x: z = (x − mean) / SD. Tells you how many SDs above or below the mean that value sits. |z| > 2 is often flagged as outlier-ish; |z| > 3 is quite rare in normal data.
Common mistakes
- Using population when you should use sample. Underestimates variability in a sample dataset.
- Mixing mean and SD from different units. Always check the scale.
- Applying normal-distribution rules to non-normal data. Skewed or multimodal data breaks the 68-95-99.7 heuristic. Plot a histogram first.
- Ignoring outliers. One extreme value can triple your SD. Robust alternatives (median absolute deviation, interquartile range) exist for heavy-tailed data.
Frequently Asked Questions
Excel has two functions: STDEV (sample, n−1 denominator) and STDEVP (population, n denominator). Make sure you are using the one that matches the sample-or-population assumption you want.
Yes — SD has the same units as your measurements (cm, dollars, seconds). Variance is in squared units, which is why SD is more readable.
Sample SD is defined for n >= 2. Below roughly n=30, consider reporting confidence intervals around the SD or using a robust alternative.
SD is still defined. For a proportion p, SD = sqrt(p × (1−p)). A sample with 60% ones has SD = sqrt(0.6 × 0.4) ~= 0.49 regardless of how many observations.
Related Tools
Age Calculator
Calculate exact age in years, months and days from a birth date, plus total days, hours and the next birthday countdown.
BMI Calculator
Calculate body mass index from height and weight. Shows WHO category, healthy-weight range and limitations of BMI.
BMR Calculator
Estimate your basal metabolic rate — the calories you burn at complete rest. Uses the Mifflin-St Jeor equation, the current clinical standard.
Calorie Calculator
Estimate daily calorie needs for your goal using Mifflin-St Jeor BMR and activity factors. Includes deficit and surplus targets.
CD Calculator
Calculate the interest and final balance on a Certificate of Deposit. Handles compounding frequency and early withdrawal penalties.
Concrete Calculator
Calculate how much concrete you need for slabs, footings, columns and walls. Get cubic yards, bag counts and material cost estimates.