VAR. S Function in Excel

This guide provides a practical overview of VAR. S Function, including its main features, benefits, limitations, and important considerations.

Description: The function performs a calculation of variance based on a sample, ignoring logical values and text. Support functions from Excel 2010 onwards.

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

Inside:

- number1, [number2]. ): The arguments in the whole need to calculate the variance, where number1 is the required argument, the next arguments are optional and contain up to 254 number arguments .

Attention:

- The VAR. S function assumes that its arguments are a sample of the population.

- Arguments can be numbers, names or arrays that contain numbers.

- If the argument is an array or a reference, only values in that array are used.

- When typing logical values and presenting numeric values into function arguments -> these values are still calculated.

- Function error occurs when arguments are text or error values cannot be converted.

- If you want to calculate both logical values and text -> use VARA.

- The equation to calculate the VAR. S function is:

[frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {{left ({n - 1} right)}}]

Inside:

+ x is the sample mean AVERAGE (number1, number2. )

+ n is the sample size.

For example:

Calculate variance based on a sample of number values in the following data table:

- In the cell to calculate enter the formula : = VAR. S (D6: D10)

- Press Enter -> variance based on a sample of number values is:

-Where the values are text or logic -> the function ignores these values:

Above are instructions and some specific examples when using the VAR. S function in Excel.

Good luck!