Calculate the variance of a sample of data.

`VAR.S(number1,[number2],...)`

- number1 - required number argument
- number2, ... - [OPTIONAL] additional number arguments

`=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.

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.

VAR.S is a function used in statistical analysis. It is used to calculate the variance of a sample of values from a population.

VAR.S assumes that its arguments are from the population and that the arguments are a representative sample of the population.

VAR.S calculates the variance of a sample of values from a population.

VAR.S uses the values of a sample of values from a population to calculate the variance.

Drop CSV