# VAR.S

Formulas / VAR.S
Calculate the variance of a sample of data.
`VAR.S(number1,[number2],...)`
• number1 - required number argument
• number2, ... - [OPTIONAL] additional number arguments

## Examples

• `=VAR.S(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10)`

The VAR.S function can be used to calculate the variance of a sample of data. For example, in Sourcetable, the formula can be used to calculate the variance of a sample of ten values.

• `=VAR.S(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15)`

The VAR.S function can also be used to calculate the variance of a larger sample of data. For example, the formula can be used to calculate the variance of a sample of fifteen values.

• `=VAR.S(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20)`

The VAR.S function can be used to calculate the variance of even larger sample of data. For example, the formula can be used to calculate the variance of a sample of twenty values.

## Summary

The VAR.S function calculates the variance of a sample of a population, ignoring empty cells, error values, text and values. It is best suited for numeric data.

• VAR.S assumes that all the arguments passed to it are samples of data.

What is VAR.S?
VAR.S is a function used in statistical analysis. It is used to calculate the variance of a sample of values from a population.
What does VAR.S assume?
VAR.S assumes that its arguments are from the population and that the arguments are a representative sample of the population.
What does VAR.S calculate?
VAR.S calculates the variance of a sample of values from a population.
What values does VAR.S use?
VAR.S uses the values of a sample of values from a population to calculate the variance. 