DVAR
Syntax:
DVAR ( database , field , criteria )
Description: Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match the specified criteria. (See the DAVERAGE function §3.17.7.77.)
Arguments:
Name |
Type |
Description |
|---|---|---|
database |
reference |
The range of cells that makes up the list or database. |
field |
text, number |
The column to which criteria shall be applied. |
criteria |
reference |
The range of cells that contains the specified conditions. |
For a detailed description of each argument, see the DAVERAGE function §3.17.7.77.
Return Type and Value: number – An estimate of the variance of a population based on the cells that correspond to the specified criteria.
example: