DVARP Function in Google Sheets

Calculates the variance of an entire population based on specified criteria.

DVARP Function

The DVARP function calculates the variance of an entire population based on specified criteria.

Syntax

DVARP(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’:

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

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

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

Notes

  • This function provides a measure of variance for an entire population rather than a sample.
  • DVAR: Calculate the variance of a sample in a database.