VAR.P

VAR.P(number1 [,number2] [..])

Returns the variance based on an entire population.

number1	The first number.
number2	(Optional) The second number.

REMARKS

* The variance is a measure of how Dispersed the values are from the mean.
* The standard deviation is a measure of how Dispersed the values are from the mean and is the square root of the variance.
* Arguments that are cell ranges containing zeros are included.
* Arguments that are cell ranges containing dates are included.
* Arguments that are cell ranges containing hidden cells are included.
* Arguments that are cell ranges containing error values are excluded.
* Arguments that are cell ranges containing logical values are excluded.
* Arguments that are cell ranges containing text are excluded.
* Arguments that are cell ranges containing empty cells are excluded.
* You can have a maximum of 255 arguments.
* You can use the VAR.S function to return the variance based on a sample.
* You can use the VARA function to return the variance based on a sample (including logical values and text).
* You can use the VARPA function to return the variance based on an entire population (including logical values and text).
* You can use the DVARP function to return the variance of the values in a column that satisfies multiple conditions based on an entire population.
* You can use the AGGREGATE and SUBTOTAL functions to return the variance based on an entire population.
* This function was added in Excel 2010 to replace the VARP function.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=VAR.P(1, 2) = 0