VARPA()
Syntax. VARPA(value1,value2,...)
Definition. This function calculates the variance based on the population. Not only numbers but also text and logical values (TRUE and FALSE) are included in the calculation.
Arguments
value1 (required) and value2 (optional). At least one and up to 255 value arguments (30 in Excel 2003 and earlier versions) corresponding to a population
Note
The VARPA() function assumes that its arguments are the entire population. If your data represents a sample of the population, you have to calculate the variance with VARA().
Arguments that contain TRUE evaluate to 1, and arguments that contain text or FALSE evaluate to 0. If you do not want to include logical values and text in the calculation, use the VARP() function.
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
