# DVARP

Formulas / DVARP
Return the variance of a population.
`DVARP(database, field, criteria, value)`
• database - required range of cells that apply the criteria to
• field - required column for the calculation
• criteria - required argument

## Examples

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

The DVARP Sourcetable function can be used to calculate the true variance in yield of a population. For example, this formula uses the data in the database from cells A4 to E10, with the "Yield" as the criteria, and the population is specified in cells A1 to A3.

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

The DVARP Sourcetable function is useful for determining the variance in yield amongst different populations of trees. For example, if the data in the database corresponds to the entire orchard population, this formula can be used to determine the variance in yield between apple and pear trees.

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

The DVARP Sourcetable function is used when data must be analyzed from a specific population. For instance, this formula is used to calculate the variance in yield of a particular population of apple and pear trees from the data in the database from cells A4 to E10.

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

The DVARP Sourcetable function is a useful tool to determine the differences in yield between two populations. This example can be used to calculate the variance in yield between apple and pear trees, if the data in the database corresponds to the entire orchard population.

## Summary

The DVARP function is used to calculate the variance of a population from a list or database. It requires three arguments: database, field and criteria, and returns a value.

• The DVARP function returns the variance of a population based on numbers in a field in a list or database.
• It can be used with any range for the criteria argument, as long as the range includes at least one column label and one cell below the column label.