Description Uses specified criteria to select records from a database, then computes the sample standard deviation of the numeric values in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DSTDEV ( database, field, criteria)
| Argument | Description |
|---|---|
| database | A reference to a range containing data that the function searches. |
| field | The column within database that contains the data you want to find the standard deviation of. |
| criteria | A reference to a range containing search criteria. |
Remarks At least two values are required to compute sample standard deviation, so if there are fewer than two numeric values in field in the selected records, DSTDEV will display the #DIV/0! error.
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 3.5119:
DSTDEV(A1:D8,"Sales 96",B10:B11)
See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEVP, DSUM, DVAR, DVARP
