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

Returns the variance based on a sample (including logical values and text).

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

* This function assumes that the arguments represent a sample from the population (as opposed to the entire population).
* This is identical to the VAR function except that text, logical values and errors are included.
* The variance is the average of the square of the deviations.
* If your data represents the entire population, you must compute the variance using VARPA.
* Any values that contain TRUE evaluate to the number 1.
* Any values that contain FALSE evaluate to the number 0.
* You can have a maximum of 30 arguments.
* You can use the VAR.P function to
* You can use the VAR.S function to
* For the Microsoft documentation refer to
* For the Google documentation refer to

1=VARA(10,20,30,40,50,60) = 350

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