DVARP()

Syntax. DVARP(database,field,criteria)

Definition. This function calculates the variance of the entire population based on the numbers in a column in a list or database that match the specified conditions.

Arguments

  • database (required) The cell range that makes up the list or database

  • field (optional) Indicates which column is used in the function

  • criteria (required) The cell range containing the field names and the filter criteria

Background. The only difference between DVARP() and DVAR() is that the DVARP() function calculates the value based on the entire population.

See Also

You will find more information about standard deviations in the description of STDEV.P() in Chapter 12 and in the description of the DVAR() function earlier in this chapter. ...

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.