The VARPA function returns the variance based on the entire population – ignores logical values and text in the population.
=VARPA(num_1,[num_2], … )
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
|num_1||The first number, cell references or range argument corresponding to a population|
|[num_2], …||Optional. Additional numbers, cell references or ranges for which you want the variance, up to a maximum of 255|
Note: The number arguments must provide a minimum of 2 numeric values to the function.
|14||=VARPA(A2:A11)||563.61||Variance of values provided, assuming that 10 is the entire population|
Note: VARAPA unction is used when calculating the variance of an entire population. If your data is just a sample of the population, you need to use the VARA function.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any values that are supplied directly to the Varpa function are text values that cannot be interpreted as numeric values|
|#DIV/0!||Occurs if none of the values supplied to the function are numeric|
Variance is a statistical measure commonly used across a set of values, to identify the amount that the values vary from the average. The equation for VARP is:
where x is the sample mean of the set of values and n is the sample size.
See Wikipedia for more information on variance.