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.

Frequently Asked Questions

What does the DVAR function do?
The DVAR function calculates the variance of a population using a sample. It takes a range of cells in a list or database and returns the estimated variance in a population using a sample.
When should I use the DVAR function?
The DVAR function should be used when you need to calculate the variance of a population using a sample. This could be useful for statistical analysis and data analysis.
How does the DVAR function calculate the variance of a population?
The DVAR function uses the sample to calculate the variance of a population. It takes the range of cells in a list or database and returns the estimated variance in a population using the sample.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.