VARPA
Formulas / VARPACalculate the variance of a population.
VARPA(value1, [value2], ...)
- number1 - Required, a number or reference
- number2 - [OPTIONAL] a number or reference
Examples
VARPA(A1:A5)The VARPA function can be used to calculate the variance of a set of numbers. For example, the formula can be used to calculate the variance of the numbers in the range A1:A5.
VARPA(B1:B10)The VARPA function can also be used to calculate the variance of a set of data points. For example, the formula can be used to calculate the variance of the data points in the range B1:B10.
VARPA(C1,C2,C3)The VARPA function can be used to calculate the variance of a set of numbers that are stored in different cells. For example, the formula can be used to calculate the variance of the numbers stored in the cells C1, C2, and C3.
VARPA(D5:D15)The VARPA function can be used to calculate the variance of a set of numbers that are stored in a column. For example, the formula can be used to calculate the variance of the numbers stored in the range D5:D15.
Summary
The VARPA function is a versatile tool for calculating the variance of a population. It takes numerical, text, array, and references as arguments and ignores empty cells and text.
- The VARPA function evaluates hardcoded values as references instead of ignoring them like VARP.
- The VARPA function handles logical values and numbers as text and ignores logical values and text in references when they are hardcoded directly as arguments.
Need help with Formulas?
Frequently Asked Questions
What is the VARPA function?
What are the arguments of the VARPA function?
Does the VARPA function ignore text and empty cells in the arguments?
Does the VARPA function assume a sample of the population?
Make Better Decisions
With Data
Analyze data, automate reports and create live dashboards
for all your business applications, without code.