DVAR Function Explained
The DVAR function in Microsoft Excel calculates the variance of a population based on a sample of values from the population. It takes two arguments: a database and a field. The database is a range of cells that contains the sample values, and the field is the column number in the database that contains the values to be used in the calculation. The function returns the variance of the sample values.
DVAR Function Syntax
DVAR(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 field argument is the same as the column index number.
- criteria: The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.