Excel Function : VAR.P
Calculates variance based on the entire population
Microsoft Excel Reference Page
Syntax and Description of the VAR.P Excel Function
The syntax for the VAR.P function in Excel is as follows: =VAR.P(array1, [array2], ...) where array1, array2, ... are the arrays or ranges of data for which you want to calculate the variance.
About VAR.P Excel Function
The VAR.P function in Excel calculates the variance of a population based on a supplied set of values. The variance is a measure of how spread out the data is from the mean. A large variance indicates that the data is spread out over a large range, while a small variance indicates that the data is clustered close to the mean.