DVARP
TheDVARP
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.
 How to use
DVARP
formula?  Examples of using
DVARP
formula DVARP
formula not working? Similar formulas to
DVARP
Usage
Use the DVARP
formula with the syntax shown below, it has 2 required parameters and 1 optional parameter:
 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.  field (required):
The name or index of the column in the database that contains the data to be used in the variance calculation.  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 theDVARP
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. Doublecheck 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. Doublecheck 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.