Estimates the variance of a population based on a sample from entries in a database that match specified conditions.
תחביר
DVAR(database, field, criteria)ארגומנטים
databaseחובה
The range of cells that makes up the list or database.
fieldחובה
The column used in the function, indicated by a label or index number.
criteriaחובה
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.