Excel Function : VAR.P

Download now!

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.