DVARP Function Explained
The DVARP Function in Microsoft Excel calculates the variance of a population based on a supplied set of values. It takes two arguments: an array of values and a sample flag. If the sample flag is set to TRUE, the function will calculate the sample variance; if it is set to FALSE, the function will calculate the population variance.
DVARP Function Syntax
DVARP(database, field, criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column number in the database that contains the values to calculate the variance for.
- criteria: The range of cells that contains the conditions you specify. You can use any range or array constant, or a reference to a range. If omitted, DVARP uses all of the records in database.