# Variance

> The average squared gap from the mean. A bigger one means more spread out.

**Field:** General Knowledge  
**Category:** Math & Statistics  
**Also known as:** Statistical Variance

## Think of it like

It is like checking how far each kid stands from the middle. Big gaps count extra.

## Definition

Variance measures how spread out numbers are around their mean. For each value, you find its gap from the mean and square it. Then you take the average of those squares. Squaring makes every gap positive and makes big gaps count much more. The square root of the variance is the standard deviation.

## Formula

```
variance = average of (value - mean)²
```

## Example

Two archers both average 8 points. Jack's arrows score 7, 8 and 9, so his variance is small. Lucy's score 4, 8 and 12, so hers is sixteen times bigger.

## Example code

```excel
=VAR.P(1, 3, 5, 7)
5
```

The gaps from the mean of 4 are 3, 1, 1 and 3. Squared they make 20, and 20 shared by 4 is 5.

## Why it matters

Many tools in statistics and machine learning work with variance. It is the step on the way to the standard deviation.

## Common mistake

Mixing up the two versions. A sample divides by one less than its count, so its variance comes out a little bigger.

## Three principles

- **Square the gaps.** Every gap turns positive.
- **Big gaps weigh more.** A gap of 3 counts as 9.
- **Squared units.** Metres turn into square metres.

## Related terms

- [Standard Deviation](https://learn.benibix.com/term/general/standard-deviation)
- [Mean (Average)](https://learn.benibix.com/term/general/mean)
- [Outlier](https://learn.benibix.com/term/general/outlier)
- [Bias-Variance Tradeoff](https://learn.benibix.com/term/ai/bias-variance-tradeoff)

## Told apart from

- [Variance vs Standard Deviation](https://learn.benibix.com/compare/variance-vs-standard-deviation): People treat variance and standard deviation as two measures of spread, and they are one measure in two forms. The variance is the average squared gap from the mean. The standard deviation is its square root, so it is back in the same units as the data. That is why people quote the standard deviation.

## Taught in

- [Standard Deviation](https://learn.benibix.com/learn/general-math/standard-deviation): Statistics, 5/10

![Four dots on a number line at 1, 3, 5 and 7, with the mean marked at 4. Below, each gap is drawn as a square: two big squares of 9 and two small squares of 1. A box adds them up: 9 plus 1 plus 1 plus 9 is 20, and 20 divided by 4 is 5.](https://learn.benibix.com/diagrams/gen-variance.svg)

---

Source: https://learn.benibix.com/term/general/variance
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
