# VARA

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

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

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

 REMARKS
 * This function assumes that the arguments represent a sample from the population (as opposed to the entire population).* 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.* 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 255 arguments.* You can use the VAR.S function to return the variance based on a sample.* You can use the VAR.P function to return the variance based on an entire population.* You can use the VARPA function to return the variance based on an entire population (including logical values and text).* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

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