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.


Frequently Asked Questions

What is the DVARP Function?
The DVARP function is a statistical function used to calculate the variance of a population using the entire population. It returns the variance of the population.
What data does the DVARP Function take?
The DVARP Function takes numbers in a field in a list or database.
What criteria must be included in the range for the criteria argument?
The criteria range must include at least one column label and at least one cell below the column header.
What type of range can be used for the criteria argument?
The DVARP function can be used with any range for the criteria argument.

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.