DSTDEV

DSTDEV sample standard deviation of the values in field in database belonging to records that match criteria

Synopsis

DSTDEV(database,field,criteria)

Arguments

database: a range in which rows of related information are records and columns of data are fields

field: a string or integer specifying which field is to be used

criteria: a range containing conditions

Description

database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.

field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.

criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.

See also

DSTDEVP.