VAR.S
Formulas / VAR.SCalculate 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.
Frequently Asked Questions
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.
