The DVAR function calculates the variance of a population based on a sample, using a specific field and criteria.


=DVAR(database, field, criteria)

database The range of cells that makes up the database including the column labels.
field The column label in the database that contains the values to consider for the variance calculation.
criteria The range of cells that contain the criteria to filter the database before calculating the variance.

About DVAR

When navigating the statistical landscape in Excel and in need of determining the variance of a population with specific criteria in mind, the DVAR function comes to the rescue. This function proves invaluable for analyzing data sets within defined parameters, offering a precise indication of the variability within the population under scrutiny. Ideal for scenarios requiring focused analysis based on predetermined conditions, DVAR streamlines the variance calculation process, facilitating insightful decision-making and trend analysis within the confines of user-defined criteria. With its ability to filter data based on specified criteria, DVAR adds a layer of precision to statistical assessments, enabling users to unveil nuanced patterns and fluctuations within the dataset with ease.


Suppose you have a dataset containing sales figures for different regions, and you want to calculate the variance of sales in the 'Units Sold' column where the 'Region' is 'East'. The DVAR formula would be: =DVAR(A1:D100, 'Units Sold', A1:A100, 'East')

Consider a scenario where you have a database of test scores for students in various subjects, and you wish to find the variance of scores in the 'Mathematics' column for students with a score above 80. The DVAR formula would look like: =DVAR(A1:D50, 'Mathematics', B1:B50, '>80')


How does the DVAR function differ from the VAR function in Excel?

The DVAR function calculates the variance of a population based on a sample and user-defined criteria, while the VAR function computes the variance of an entire population. DVAR allows you to filter the data before calculating the variance, providing a more targeted analysis.

Can I use the DVAR function with multiple criteria to filter the database?

Yes, you can utilize the DVAR function with multiple criteria by adding additional criteria ranges. Simply specify each criterion range in the formula to narrow down the dataset before calculating the variance.

In what scenarios is the DVAR function particularly useful?

The DVAR function is especially beneficial when you need to examine the variability within a dataset based on specific conditions or criteria. It is handy for conducting focused analyses and extracting insights from structured data sets.

Related functions