DSTDEVP ( database , field , criteria )

Description: Computes the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match the specified criteria. (See the DAVERAGE function §3.17.7.77.)

Arguments:

Name	Type	Description
database	reference	The range of cells that makes up the list or database.
field	text, number	The column to which criteria shall be applied.
criteria	reference	The range of cells that contains the specified conditions.

For a detailed description of each argument, see the DAVERAGE function §3.17.7.77.

Return Type and Value: number – The standard deviation of a population based on the cells that correspond to the specified criteria.

[Example: Using the data in the example in the DAVERAGE function §3.17.7.77:

The true standard deviation in the yield of apple and pear trees if the data in the database is the entire population is computed by DSTDEVP(A4:E10,"Yield",A1:A3), which results in 2.65.

end example]