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 a possible outlier; |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’s current functions are STDEV.S (sample, n−1 denominator) and STDEV.P (population, n denominator). Older STDEV and STDEVP remain for compatibility, so make sure the function 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
BMI Calculator
Calculate body mass index from height and weight. Shows WHO category, healthy-weight range and limitations of BMI.
GPA Calculator
Calculate grade point average from letter grades and credit hours. Supports US 4.0 and 5.0 honors scales with the standard A/B/C/D letter table.
Inflation Calculator
Calculate the equivalent purchasing power of a dollar across any two years using historical CPI data from 1913 to today.
Scientific Calculator
Full scientific calculator with trig, log, exponents, factorial, memory, parentheses and DEG/RAD toggle. Runs in your browser.
Binomial Probability Calculator
Compute exact, cumulative and tail probabilities for a binomial distribution. Enter n trials, p success rate and k successes.
Calorie Calculator
Estimate daily calorie needs for your goal using Mifflin-St Jeor BMR and activity factors. Includes deficit and surplus targets.