# VAR.S

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

Returns the variance based on a sample.

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

 REMARKS
 * This function was added in Excel 2010 to replace the VAR 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.* You can have a maximum of 255 arguments.* You can use the VARA function to return the variance based on a sample (including logical values and text).* 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).* You can use the DVAR function to return the variance of the values in a column that satisfies multiple conditions based on a sample.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =VAR.S(1, 2) = 1