DVARP (PQL - xl)

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

Syntax

DVARP(database, field, criteria)

Function Arguments

Name

Description

Type

Optional

database

Range of cells that make up the database; cell range reference

CellRange

field

Column in the database, referred to by label or index

StringOrNumber

criteria

Range of cells that specify which rows in the database are used; cell range reference

CellRange

Comments

This function is the same as the Microsoft Excel 'DVARP' function - using the same inputs, logic and outputs.