# DSTDEV

Formulas / DSTDEV
The DSTDEV function is a worksheet function used to calculate the standard deviation of a population using a sample of numbers in a column of a table.
`DSTDEV(database, field, criteria)`
• Database - the range of cells to apply the criteria to
• Field - the column to use in the calculation
• Criteria - the range of cells with the criteria

## Examples

• `=DSTDEV(A5:E11, "Yield", A1:A3)`

The DSTDEV function can be used to calculate the standard deviation of a set of values. In this example, this formula would be used to calculate the standard deviation of the yield of apple and pear trees in a given orchard.

• `=DSTDEV(A5:E11, "Yield", A1:A3, TRUE)`

The DSTDEV function can also be used to calculate the standard deviation of a set of values when the data is grouped. This example would calculate the standard deviation of the yield of apple and pear trees in a given orchard, taking into account the grouping of the data.

• `=DSTDEV(A5:E11, "Yield", A1:A3, TRUE, B1:B3)`

The DSTDEV function can also be used to calculate the standard deviation of a set of values when the data is weighted. This example would calculate the standard deviation of the yield of apple and pear trees in a given orchard, taking into account the weighting of the data.

• `=DSTDEV(A5:E11, "Yield", A1:A3, TRUE, B1:B3, TRUE)`

The DSTDEV function can also be used to calculate the standard deviation of a set of values when the data is both grouped and weighted. For example, this formula would calculate the standard deviation of the yield of apple and pear trees in

## Summary

The DSTDEV function is a worksheet function used to calculate the standard deviation of a population using a sample of numbers in a column of a table.

• The DSTDEV function is used to calculate the standard deviation of data from records that match a set criteria.
• The standard deviation is determined from a subset of data. 