DVARP

Definition: DVARP is a function that returns the variance of a population based on an entire database.

Syntax: =DVARP(database, field)

Situation: This formula is suitable when you need to find the variance of a population based on an entire database.

Example: If you have a database with employee information and want to find the variance of salaries for all employees, the formula =DVARP(A1:D10, “Salary”) can be used.