The VAR.S function returns the variance based on a sample – ignores logical values and text in the sample.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The VAR.S function replaces the VAR function included in earlier versions of Excel.
=VAR.S(num_1,[num_2], … )
|num_1||The first number, cell references or range argument corresponding to a population|
|[num_2], …||Optional. Additional numbers, cell references or ranges for which you want the variance, up to a maximum of 255|
|14||=VAR.S(A2:A11)||626.23||Variance of values provided using the VAR.S function, which assumes that 10 is only a sample population|
|15||=VAR.P(A2:A11)||563.61||Variance of values provided, assuming that 10 is the entire population. The result is different from VAR.S|
Note: The VAR.S function is used when calculating the variance for a sample of a population. If you are calculating the variance for an entire population, you need to use the VAR.P function.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any values that are supplied directly to the function are text values that cannot be interpreted as numeric values|
|#DIV/0!||Occurs if less than 2 numeric values have been supplied to the function|
Variance is a statistical measure commonly used across a set of values, to identify the amount that the values vary from the average.
When your data set is a sample of a population, rather than an entire population, you should use a slightly modified form of variance, known as the Sample Variance.
The equation for VAR.S is:
where x is the sample mean of the set of values and n is the sample size.
See Wikipedia for more information on variance.