DVAR Function in Google Sheets

Calculates the variance of a database field based on specified criteria.

DVAR Function

The DVAR function calculates the variance of a database field based on specified criteria.

Syntax

DVAR(database, field, criteria)
  • database: The range of cells that makes up the database.
  • field: The column in the database for which variance is calculated (either as a number or column label).
  • criteria: The range that specifies which records should be included in the variance calculation.

Examples

  1. Basic Example

Calculate the variance of the ‘Sales’ field in a database, where ‘Region’ is ‘West’:

=DVAR(A1:D100, 2, E1:F2)
  1. With Different Criteria

To calculate the variance of ‘Profit’ for ‘Product A’:

=DVAR(A1:D100, "Profit", G1:H2)

Notes

  • This function is useful for statistical analysis in large datasets where specific criteria are used.
  • DVARP: Calculate the variance for the entire population in a database.