This function calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match the specified conditions
- Library: PQL \ Spreadsheet \ Database
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Range of cells that make up the database; cell range reference
Column in the database, referred to by label or index
Range of cells that specify which rows in the database are used; cell range reference
This function is the same as the Microsoft Excel 'DVARP' function - using the same inputs, logic and outputs.