Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
DVARP() is a function in Google Sheets that allows you to calculate the variance of an entire population of values in a specified field of a database that match specific criteria.
The function takes three arguments:
The database: A range of cells that contains the entire database.
The field: The column or row in the database that contains the values you want to use in the calculation.
The criteria: A range of cells that specifies the conditions that the data must meet to be included in the calculation.
For example, if you have a database of ages for a population of people and you want to calculate the variance of the ages for people who live in a specific city, you could use the DVARP() function to do so.