You can use the **VARP**, **VAR.P,** or **VARPA** functions in Excel to calculate population variance.

## Data Example

The following is the data example for population variance.

## Example of VARP()

Type **=VARP(B2:B12)** in a cell in Excel to calculate population variance. The population variance is 46.23.

## Example of VAR.P()

Type **=VAR.P(B2:B12)** in a cell in Excel to calculate population variance. The population variance is 46.23.

## Example of VARPA()

Type **=VARPA(B2:B12)** in a cell in Excel to calculate population variance. The population variance is 46.23.

## Further Reading

The following tutorial shows the formula for population variance.

Population Variance Formula and Calculation by Hand

The following tutorials show how to calculate sample variance by hand and via Excel.