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

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

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

Remarks

* This function assumes that the arguments represent the entire population (as opposed to a sample).
* This is identical to the VAR.P function except that text and logical values are included.
* VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance using VARA.
* 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 30 arguments.
* For the Microsoft documentation refer to support.office.com

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

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top