# DVAR

Formulas / DVAR
Calculate the population variance using a sample.
`DVAR(database, field, criteria)`
• database - required, the range of cells that apply the criteria to
• field - required, the column to use in the calculation
• criteria - required, the range of cells that contain the criteria

## Examples

• `=DVAR(A4:E10, "Yield", A1:A3)`

For this example, the DVAR function is used to find the total yield of a range of cells. This can be done by setting the criteria of the DVAR function to match the column labels in the database.

• `=DVAR(A4:E10, "Freight", A1:A3)`

The DVAR function can also be used to find the total amount of freight costs for a certain range of cells. For example, this formula can be used to find the total freight costs, where A4:E10 is the range of cells, "Freight" is the criteria, and A1:A3 is the column labels.

• `=DVAR(A4:E10, "Items", A1:A3)`

The DVAR function can be used to find the total number of items in a certain range of cells. For example, this formula can be used to find the total number of items, where A4:E10 is the range of cells, "Items" is the criteria, and A1:A3 is the column labels.

## Summary

The DVAR function is used to calculate the variance of a population by utilizing a sample of numbers found in a specific field of a list or database. It requires the database, field and criteria arguments in order to select the relevant elements.

• The DVAR function takes three arguments: database, field, and criteria. All three are required.
• The criteria argument can be any range, and does not have to be a column or a cell below the column in the database.