Paste a data set and get its sample or population variance instantly — with the mean, standard deviation, sum of squared deviations, and a full row-by-row breakdown of how every value contributes.
Separate with commas, spaces, or new lines.
| x | x − x̄ | (x − x̄)² |
|---|---|---|
| 2 | −3 | 9 |
| 4 | −1 | 1 |
| 4 | −1 | 1 |
| 4 | −1 | 1 |
| 5 | 0 | 0 |
| 5 | 0 | 0 |
| 7 | 2 | 4 |
| 9 | 4 | 16 |
| Σ(x − x̄)² | 32 | |
Variance is in squared units; its square root (the standard deviation) returns to the original units.
Variance is the single number that answers “how spread out is this data?” It takes the distance of every value from the mean, squares those distances so they cannot cancel out, and averages them. The squaring is the key idea — it punishes far-flung values heavily and keeps the result positive.
Four steps. The only choice is the divisor in the last one.
Add up all the values and divide by how many there are. This average x̄ is the centre every deviation is measured from.
For each value, compute x − x̄ and square it. Squaring removes negative signs so deviations on both sides count.
Sum every squared deviation into a single total — the sum of squares.
Divide the sum of squares by n for a population, or by n − 1 for a sample. The quotient is the variance.
The same data set, computed as a sample and as a population, plus the smallest valid sample — every figure is calculated live, not hardcoded.
Variance is the raw material of risk, quality, and uncertainty across many fields.
Both start identically — find the mean, then sum the squared deviations. Only the divisor differs.
| Population | Sample | |
|---|---|---|
| Symbol | σ² (sigma squared) | s² |
| Divisor | n | n − 1 |
| When to use | Data is the entire group | Data is a sample of a larger group |
| Bias | Exact for the population | Unbiased estimate (Bessel's correction) |
| Square root | σ — population std. dev | s — sample std. dev |
For a fixed sum of squares, how much do the two divisors change the answer? The gap is huge for tiny samples and vanishes for large ones.
| n | Population σ² | Sample s² | Difference |
|---|---|---|---|
| 2 | 20 | 40 | +100% |
| 3 | 13.33 | 20 | +50% |
| 4 | 10 | 13.33 | +33.33% |
| 5 | 8 | 10 | +25% |
| 8 | 5 | 5.71 | +14.29% |
| 10 | 4 | 4.44 | +11.11% |
| 20 | 2 | 2.11 | +5.26% |
| 30 | 1.33 | 1.38 | +3.45% |
| 50 | 0.8 | 0.82 | +2.04% |
| 100 | 0.4 | 0.4 | +1.01% |
With a small sample the choice of divisor matters a lot — at n = 2 the sample estimate is double the population one. By n = 100 the gap is about 1%, which is why the distinction fades for large data sets.
A handful of facts that explain how variance behaves — and the mistakes that trip people up.
Variance sits at the centre of a small family of spread statistics — each is one short step away.

The mean is the average of a set of numbers: add them all up and divide by how many there are. This guide shows the formula, a worked example, and how the mean differs from the median and mode.

Use STDEV.S or STDEV.P in Excel, choose the right one for your data, and check the result against a worked example.

A friendly, beginner-focused guide to understanding and calculating range in statistics. Learn what range means, how to compute it, real-life applications, and common mistakes to avoid.