1. Home
  2. Statistics
  3. Variance Calculator
Statistics

Variance Calculator

Measure the average squared deviation from the mean.

Your numbers

Results update as you type. Nothing you enter is sent anywhere.

Result

1

Population variance = Σ(x − mean)²/N; sample variance uses N−1. Up to 10,000 finite numbers. Sample variance estimates population variability using Bessel’s correction.

Formula used

Population variance = Σ(x − mean)²/N; sample variance uses N−1

Variance measures how spread out a set of numbers is, as the average squared distance from the mean. It is a building block for standard deviation, statistical tests and investment risk measures. Enter your numbers, choose population or sample, and the calculator returns the variance.

How to use the Variance calculator

  1. Enter the data in Numbers, comma separated, for example 4, 8, 6, 5, 7.
  2. Choose Model. Pick population if your list contains every member of the group you care about; pick sample if it is a subset used to estimate a larger group.
  3. A sample needs at least two values, since one value gives no information about spread.
  4. Read the variance. Take its square root for the standard deviation, or use the Descriptive Statistics Calculator, which reports both.

How the variance calculation works

FormulaPopulation variance = Σ(x − mean)²/N; sample variance uses N−1

Population versus sample: N or N − 1

Population variance divides the sum of squared deviations by N, the number of values. Sample variance divides by N − 1. A sample's own mean sits closer to its data points than the true population mean does, so its squared deviations run a little small; dividing by one less corrects for that on average. The adjustment is called Bessel's correction.

The difference shrinks as data grows. With 5 values, sample variance is 25% larger than population variance (dividing by 4 instead of 5). With 1,000 values, the gap is about 0.1%. Statistics courses usually want the sample version for data collected from surveys or experiments, while a teacher's grade list for one class is a population.

Reading the units

Because deviations are squared, variance is in squared units. Heights in centimeters have a variance in square centimeters, which is hard to picture. That is why standard deviation, the square root of variance, is the figure most people report: it returns to the original units.

Variance is very sensitive to outliers, since a value twice as far from the mean contributes four times as much. A single data entry error can dominate the result, so scan your list for typos before relying on it.

Worked example

Sample variance of five daily readings

Numbers, comma separated: 4,8,6,5,7 · Model: sample

  1. Mean: (4 + 8 + 6 + 5 + 7) ÷ 5 = 30 ÷ 5 = 6.
  2. Deviations: −2, 2, 0, −1, 1.
  3. Squares: 4, 4, 0, 1, 1, which add to 10.
  4. Sample variance: 10 ÷ (5 − 1) = 2.5. As a population it would be 10 ÷ 5 = 2.

Result: 2.5

Assumptions and limits

Up to 10,000 finite numbers. Sample variance estimates population variability using Bessel’s correction.

Formula and worked examples last checked November 20, 2026. Spotted a problem? Report an error.

Frequently asked questions

What is the formula for variance?

Population variance is Σ(x − mean)² ÷ N, and sample variance is Σ(x − mean)² ÷ (N − 1). Find the mean, subtract it from each value, square each result, add the squares, then divide.

How do I get standard deviation from variance?

Take the square root. A variance of 2.5 gives a standard deviation of about 1.58. Use the same population or sample choice for both.

Can variance be negative?

No. It is an average of squared numbers, so it is zero or positive. A variance of exactly 0 means every value in the list is identical.

Should I use sample or population variance in Excel?

Excel's VAR.S treats your data as a sample, and Microsoft directs you to VAR.P when the data represents the entire population; those match the sample and population options here. Choose based on whether your data covers the whole group or only part of it.

Sources