Updated · Built and checked by the PlinzoTools team, formulas tested against published sources
Calculate sample or population variance for any data set.
4.5714
Variance measures the average squared deviation from the mean -- the same underlying spread measure as standard deviation, but on a squared scale.
Enter your data set, then choose sample or population. Variance appears instantly.
Variance (population) = Σ(x - mean)² / n
Variance (sample) = Σ(x - mean)² / (n - 1)
The formulas above are easier to follow with a small data set. Take the hypothetical values 1, 2, 3.
Population variance = 2 / 3 ≈ 0.6667
Sample variance = 2 / (3 - 1) = 1
Squaring is what makes variance useful and slightly awkward at the same time. It stops positive and negative deviations from cancelling out, and it gives larger deviations more weight, but it also means the answer is in squared units. If your data is in dollars, the variance is in dollars squared, which is hard to picture. Taking the square root gives you the standard deviation back in ordinary units.
Consider the default data set 2, 4, 4, 4, 5, 5, 7, 9, with a mean of 5. The squared deviations are 9, 1, 1, 1, 0, 0, 4, and 16, which add up to 32. The population variance is 32 / 8 = 4, and the sample variance is 32 / 7, about 4.5714. Switching between sample and population in the tool shows exactly this difference for the same numbers.
Pick Sample when your list is a portion of a larger group and you want to estimate that group's variance. The n - 1 denominator compensates for the fact that the sample mean is calculated from the same data, which would otherwise make the spread look a little too small. Pick Population only when your list includes every member of the group. With large data sets the difference is small, but with a handful of values it is significant, as the 0.6667 versus 1 above shows.
Variance describes spread in the data you supplied. It does not by itself tell you why the data varies or whether a difference is statistically significant.
Standard deviation is usually more interpretable since it's in the same units as your original data; variance is in squared units. See the Standard Deviation Calculator.
Yes, when the standard deviation is below 1. For example, a standard deviation of 0.5 gives a variance of 0.25. Above 1 the variance is larger.
For a population of one value, the variance is 0. The sample version cannot be calculated from one value because it divides by n - 1, which would be zero.
Squaring prevents positive and negative deviations from cancelling out and gives larger deviations more weight than small ones.
Take the square root. The result is the standard deviation, which uses the same units as your original data.
Reference: NIST Weights and Measures