# 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.