VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
The following article introduces you to the VAR.S function - one of the functions in the statistical function group is very popular in Excel.
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel Picture 1
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:
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel Picture 2
- In the cell to calculate enter the formula : = VAR.S (D6: D10)
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel Picture 3
- Press Enter -> variance based on a sample of number values is:
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel Picture 4
-Where the values are text or logic -> the function ignores these values:
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel Picture 5
Above are instructions and some specific examples when using the VAR.S function in Excel.
Good luck!
You should read it
- VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
- VARA - Function that calculates variance based on a sample, including logical values and text in Excel
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
- STDEV.S function - The function returns the standard deviation based on a sample in Excel
- VARP function - Functions for calculating variance based on an entire population in Excel
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel
- VAR function - The function of estimating variance based on a sample in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- STDEVPA function - The function of estimating standard deviations based on an entire population including both text and logical values in Excel
- MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
- How to use the SUMIF function in Excel
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
May be interested
VARA - Function that calculates variance based on a sample, including logical values and text in Excel
VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excel
Z.TEST function - The function returns one-sided value of the z test in Excel
LINEST function - The function returns a line description array using the least square method in Excel
CELL function - The function returns information about the format or content of a cell in Excel
ERROR.TYPE function - The function returns the number corresponding to one of the error values in Microsoft Excel