Returns the population variance of values in a column of a Calc 'database' table, in rows which meet specified criteria.
DVARP(database_table; field; criteria_table)
- database_table is a range defining the data to be examined.
- field is the column to examine. It may be a column number (1 is the first column of the database table, 2 is the second ...) or a column header (enclosed in quotation marks ””) or a cell referring to a column header.
- criteria_table is a range containing criteria, which are used to select which rows of the database_table to examine.
- The Database functions overview describes these parameters in detail.
DVARP returns the population variance, which assumes that the chosen rows of the database_table are an entire normally distributed population. If the chosen data are a sample of the population, use * DVARP instead. The DVARP calculation uses this formula:
where N is the number of values included and xi are those values.
DVARP ignores any cell containing text in the field column.
Simply put, variance is a measure of how widely spread data values are. It is the square of the standard deviation (see * DSTDEV, * DSTDEVP). Variance is a reliable measure only if there is enough data to examine.
In this spreadsheet: