DSTDEVP


Description Uses specified criteria to select records from a database, then computes the population 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 DSTDEVP ( 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 one value is required to compute population standard deviation, so if there are fewer than one numeric values in field in the selected records, DSTDEVP will display the #DIV/0! error.

Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 2.8674:

DSTDEVP(A1:D8,"Sales 96",B10:B11)

See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSUM, DVAR, DVARP