VARP

Formulas / VARP
Calculate the variance of a population.
VARP(number1, [number2], [number3], ...[number255])
  • number1 - required, value or array of values
  • number2 - [OPTIONAL], value or array of values
  • ... - [OPTIONAL], value or array of values

Examples

  • =VARP(A2:A11)

    The VARP function is used to calculate the variance of a population of data. In the example above, this function will return the variance of the breaking strengths of all the tools, assuming that 10 tools are produced.

  • =VAR(A2:A11)

    The VAR function is used to calculate the variance of a sample of data. In the example above, the function will return the variance of the breaking strengths of all the tools, assuming that only a sample of the population is used.

  • =VARP(A2:A11,B2:B11)

    The VARP function can also be used to calculate the variance of multiple sets of data. For example, if there are two sets of data in columns A and B, the VARP function can be used to calculate the variance of both sets of data.

  • =VARP(A2:A11)

    The VARP function can also be used with an array of data. In this example, the function will return the variance of the data in cells A2 through A11.

Summary

The VARP function calculates the population variance, while the VAR function calculates the sample variance. VARPA also takes into account logical values and text when determining the variance.

  • The VARP function only considers numerical values when evaluating cell references.
  • Text and logical values in cell references are ignored when using the VARP function.


Frequently Asked Questions

What is the VARP function?
The VARP function calculates the variance of a population. It takes as its arguments the entire population, including both numeric values and text representations of numbers.
What are the new functions associated with the VARP function?
The new functions associated with the VARP function may include:
  • Improved accuracy
  • Better naming conventions
  • Better reflection of usage
  • VAR.P
How does the VARP function handle empty cells, text, and error values in the argument?
The VARP function can ignore empty cells, text, and error values in the argument.
What is VARPA?
VARPA is the reference used in the VARP function to include both numeric values and text representations of numbers.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.