DSTDEV
Formulas / DSTDEVThe 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.
Frequently Asked Questions
What is the DSTDEV Function?
Are the Arguments for the DSTDEV Function Required?
What Should I Include in the Criteria Argument?
