VAR.P()/VARP()
Syntax. VAR.P(number1,number2,...)
Definition. This function calculates the variance based on the population.
Arguments
number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) corresponding to a population
Note
The VAR.P() function assumes that its arguments are the entire population. If your data represents a sample of the population, calculate the variance with VAR.S() or VARA().
Logical values (TRUE and FALSE) and text are ignored. If you want to include logical values in the calculation, use the VARPA() function.
Background. Because the only difference between VAR.P() and VAR.S() is that VAR.P() doesn’t calculate the variance based on a sample but based on the entire population, ...
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.
