# VAR

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

Returns the variance based on a sample.

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

 REMARKS
 * VAR.S was added in Excel 2010 to replace this function.* 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.* This function assumes that the arguments represent a sample from the population (as opposed to the entire population).* Text and logical values such as True and False are ignored.* You can have a maximum of 255 arguments * If you do not want to count any arguments that are text, logical values or errors you can use the VARA function.* You can use the VAR.P function to return the variance based on an entire population.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

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