VARPA

VARPA(value1 [,value2] [..])

Returns the variance based on an entire population (including logical values and text).

value1	The first value.
value2	(Optional) The second value.

REMARKS

* This function assumes that the arguments represent the entire population (as opposed to a sample).
* 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 contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
* Using the data from the VARA example and assuming that only 10 tools are produced during the production run, VARPA measures the variance of breaking strengths for all the tools.
* You can have a maximum of 255 arguments.
* You can use the VAR.P function to return the variance based on an entire population.
* 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).
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=VARPA(10, 20, 30, 40, 50, 60) = 291.667