Description Uses specified criteria to select records from a database, then computes the sample variance of the numeric values in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DVAR ( database, field, criteria)
Argument | Description |
---|---|
database | A reference to a range containing data that the function searches. |
field | The column within database that contains the data you want to find the variance of. |
criteria | A reference to a range containing search criteria. |
Remarks At least two values are required to compute sample variance, so if there are fewer than two numeric values in field in the selected records, DVAR will display the #DIV/0! error.
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 12.333:
DVAR(A1:D8,"Sales 96",B10:B11)
See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVARP