VAR.P

Formulas / VAR.P
Calculate the variance of a population.
=VAR.P(number1,[number2],...)
  • number1 - required argument that is the first number in the population
  • number2, ... - [OPTIONAL] additional numbers in the population

Examples

  • =VAR.P(A1, A2, A3, A4, A5, A6)

    The VAR.P function can be used to calculate the variance of a set of data. To use this function, you must specify the range of the data you want to include in the calculation. For example, to calculate the variance of the data in cells A1 through A6, you can use the formula above.

  • =VAR.P(A1, A3, A5, A6)

    The VAR.P function can also be used to calculate the variance of a subset of data. For example, if you only want to calculate the variance of the data in cells A1, A3, A5, and A6, you can use the preceding formula.

  • =VAR.P(A1:A6)

    The VAR.P function can also be used to calculate the variance of a range of data, rather than individual cells. For example, to calculate the variance of the data in cells A1 through A6, you can use the formula above.

  • =VAR.P(A1, A3, A5, A6)

    The VAR.P function can also be used to calculate the variance of a range of data with non-consecutive cells. For example, to calculate the variance of the data in cells A1, A3, A5, and A6, you can use the preceding formula.


Summary

The VAR.P function is a useful tool for calculating the variance of a population. It can take numerical, array, reference, and even error values or text as arguments.

  • The VAR.P function can take up to 254 arguments, and these can be numbers, names, arrays, or references. Empty cells, text, and logical values will be ignored.
  • The VARPA function can be used to evaluate logical values and text.

Frequently Asked Questions

What is the VAR.P function?
The VAR.P function is used to calculate the variance of a population. It ignores values and text in the population and takes numerical, array and references as arguments.
What types of arguments does the VAR.P function take?
The VAR.P function takes numerical arguments, array arguments, and references as arguments.
Does the VAR.P function ignore values and text?
Yes, the VAR.P function ignores values and text in the population.
What is the syntax for the VAR.P function?
The syntax for the VAR.P function is: VAR.P(number1, [number2], …).
What are the arguments for the VAR.P function?
The arguments for the VAR.P function are:
  • number1: This is the first number in the population.
  • number2 (optional): This is the second number in the population.
  • …: This indicates that there can be more numbers in the population.

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