DVAR
Formulas / DVARCalculate 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.
Frequently Asked Questions
What does the DVAR function do?
When should I use the DVAR function?
How does the DVAR function calculate the variance of a population?
