DVAR(database,field,criteria)
DVAR function returns the estimate of variance of a population based on a sample. The population consists of numbers that match conditions specified.
database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field specifies which column is used in the function. If field is an integer, for example 2, the second column is used. Field can also be the label of a column. For example, ``Age'' refers to the column with the label ``Age'' in database range.
criteria is the range of cells which contains the specified conditions. The first row of a criteria should contain the labels of the fields for which the criteria are for. Cells below the labels specify conditions, for example, ``>3'' or ``<9''. Equality condition can be given simply by specifying a value, e.g. ``3'' or ``John''.
Each row in criteria specifies a separate condition. If a row in database matches a row in criteria, then that row is counted. Technically speaking, this a boolean OR operation between the rows in criteria.
If criteria specifies more than one column, then each of the conditions in the specified columns must be true for the row in database to match. Technically speaking, this is a boolean AND operation between the columns in criteria.
Let us assume that the range A1:C7 contain the following values:
Name Age Salary
John 34 54342
Bill 35 22343
Clark 29 34323
Bob 43 47242
Susan 37 42932
Jill 45 45324
In addition, the cells A9:B11 contain the following values:
Age Salary
<30
>40 >46000
DVAR(A1:C7, "Age", A9:B11) equals 98.
DVAR(A1:C7, "Salary", A9:B11) equals 83450280.5.