Returns the sample standard deviation of values in a column of a Calc 'database' table, in rows which meet specified criteria.
DSTDEV(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.
DSTDEV returns the sample standard deviation, which assumes that the chosen rows of the database_table contain a random sample of a normally distributed population. If the chosen data are the entire population, use * DSTDEVP instead. The DSTDEV calculation uses this formula:
where N is the number of values included and xi are those values.
DSTDEV ignores any cell containing text in the field column.
Simply put, standard deviation is a measure of how widely spread data values are. It is the square root of the variance (see * DVAR, * DVARP). Standard deviation is a reliable measure only if there is enough data to examine.
In this spreadsheet: