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.

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV