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.
![Data example of population](https://tidystat.com/wp-content/uploads/2023/01/image-23.png)
![Population data in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-24.png)
Example of VARP()
Type =VARP(B2:B12) in a cell in Excel to calculate population variance. The population variance is 46.23.
![Example of using varp() to calculate population variance in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-26.png)
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 using var.p() to calculate population variance in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-25.png)
Example of VARPA()
Type =VARPA(B2:B12) in a cell in Excel to calculate population variance. The population variance is 46.23.
![Example of using varpa() to calculate population variance in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-27.png)
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.