This function calculates the variance of the entire population based on the numerical values in a column within a list or database that match the specified conditions.
Syntax
DVARP(database; field; criteria)
Arguments
- database (required): The cell range that constitutes your list or database.
- field (optional): Indicates which column the function will use.
- criteria (required): The cell range containing the field names and the filter criteria.
Background
The only difference between DVARP() and DVAR() is that the DVARP() function calculates the value based on the entire population.
Example
You have already calculated the variance for the sales of a product based on a sample using the DVAR() function. Now, you want to calculate the variance based on the entire population (see Figure below).
To put this into context, you also need to calculate the mean, as shown in Figure below.
The variance calculation based on a population meeting the criteria is $83,705.47. If you take the square root of this calculated variance, the result will be the standard deviation based on a population (refer to the DVAR() function, described earlier in this chapter).