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.

Frequently Asked Questions

What is the DSTDEV Function?
The DSTDEV function is used to estimate the standard deviation of a population using a sample. It takes three arguments: database, field, and criteria.
Are the Arguments for the DSTDEV Function Required?
Yes, all three arguments are required for the DSTDEV function.
What Should I Include in the Criteria Argument?
The criteria argument should include at least one column and at least one cell below the column for specifying a condition. This range of cells can be any range you want.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV