Check Sheet Logo
Check Sheet

DVARP

The DVARP function calculates the variance of a population based on a database. It returns the variance of a column of numbers in a list or database that match conditions specified in another column. This function is useful in statistics to analyze data sets.

Usage

Use the DVARP formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:

=DVARP(database, field, criteria)
Parameters:
  1. database (required):
    The range of cells that makes up the database table. Each column of the database must have a heading that matches the field argument.
  2. field (required):
    The name or index of the column in the database that contains the data to be used in the variance calculation.
  3. criteria (optional):
    The range of cells that contains the conditions to be met. This range must have the same number of rows and columns as the database, and the first row must contain the column headings.

Examples

Here are a few example use cases that explain how to use the DVARP formula in Google Sheets.

Calculate the variance of a column of numbers

Use DVARP to calculate the variance of a column of numbers in a database.

Calculate the variance of a column of numbers based on criteria

Use DVARP with a criteria range to calculate the variance of a column of numbers in a database that meet certain conditions.

Calculate the variance of a column of numbers using a column index

Use DVARP with a column index instead of a column name to calculate the variance of a column of numbers in a database.

Common Mistakes

DVARP not working? Here are some common mistakes people make when using the DVARP Google Sheets Formula:

Incorrect database range

One common mistake when using the DVARP formula is to select a database range that does not include all the necessary columns or rows. Ensure that the range you select includes all the data you want to analyze.

Incorrect field argument

Another common mistake when using the DVARP formula is to provide an incorrect or misspelled field argument. Double-check the spelling and ensure that the field exists in the selected database range.

Incorrect criteria argument

A third common mistake when using the DVARP formula is to provide an incorrect or misspelled criteria argument. Double-check the spelling and ensure that the criteria match the field you want to analyze.

Related Formulas

The following functions are similar to DVARP or are often used with it in a formula:

  • VARP

    The VARP function is a statistical function in Google Sheets that returns the variance of a population based on a set of values. Variance is a measure of how spread out a set of data is from its average value. This function is commonly used in statistics and data analysis.

  • DSUM

    The DSUM function is a database function that calculates the sum of a set of values in a specified field, subject to the provided criteria. It is commonly used for filtering large data sets based on certain criteria and calculating the total sum of a particular field that matches the criteria.

  • DAVERAGE

    The DAVERAGE function calculates the average value of a specified field in a database that matches the given criteria. The function is commonly used in financial and business analysis to calculate averages based on specific conditions.

Learn More

You can learn more about the DVARP Google Sheets function on Google Support.