Estimates the variance of a population based on a sample from entries in a database that match specified conditions.
Söz dizimi
DVAR(database, field, criteria)Bağımsız değişkenler
databasezorunlu
The range of cells that makes up the list or database.
fieldzorunlu
The column used in the function, indicated by a label or index number.
criteriazorunlu
The range of cells that contains the conditions you specify.
The DVAR function evaluates a list or database using a sample of the population. It filters data based on criteria you define and calculates the variance of the numbers in the specified field.
=DVAR(A1:C10, "Profit", E1:E2)→125.4Calculates the sample variance of the 'Profit' column for rows matching the criteria in E1:E2.
Prepare your data
Ensure your database has column headers and your criteria range includes the header and the condition.
Enter the formula
Type =DVAR() and reference your database range, the specific field name, and the criteria range.
DVAR calculates variance based on a sample, while DVARP calculates variance based on the entire population.