Calculate Population Variance in Excel

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
Data example of population data
Population data in Excel
Population data in Excel

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
Example of using varp() to calculate population variance in Excel

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
Example of using var.p() to calculate population variance in Excel

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
Example of using varpa() to calculate population variance in Excel

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.

Sample Variance Formula and Calculation by Hand

Calculate Sample Variance in Excel

Leave a Comment