[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
DSTDEV ( database , field , criteria )
Description: Estimates the standard deviation of a population based on a sample 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 |
The range of cells that makes up the list or database. | |
|
text, number |
The column to which criteria shall be applied. | |
|
criteria |
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 – An estimate of 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 estimated standard deviation in the yield of apple and pear trees if the data in the database is only a sample of the total orchard population is computed by DSTDEV(A4:E10,"Yield",A1:A3), which results in 2.97.
end example]