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

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV