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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV