DSTDEVP

Formulas / DSTDEVP
Calculate the standard deviation of a population of data.
=DSTDEVP(database, field, criteria)
  • database - includes field headers
  • field - name or index of the field to be queried
  • criteria - range of cells with headers that match those in the data set

Examples

  • =DSTDEVP(B7:C13,"Height",B4:C5)

    The DSTDEVP function can be used to calculate the standard deviation of a field from a given range. For example, the formula returns the standard deviation of heights for the group "Fox" where the field argument is "Height" and the field argument is inclusively between B4:C5.

  • =DSTDEVP(B7:C13,2,B4:C5)

    The DSTDEVP function can also be used to calculate the standard deviation of a field from a given range using the field index number instead of the field name. For example, the formula returns the standard deviation of heights for the group "Fox" where the field argument is 2 and the field argument is inclusively between B4:C5.

  • =DSTDEVP(B7:C13,B17:C20,"Height",B4:C5)

    The DSTDEVP function can also be used to calculate the standard deviation of a field from multiple ranges. For example, the formula returns the standard deviation of heights for the group "Fox" from both the B7:C13 and B17:C20 ranges where the field argument is "Height" and the field argument is inclusively between B4:C5.

  • =DSTDEVP(B7:C13,"Height","Weight","Age",B4:C5)

    The DSTDEVP function can also be used to calculate the standard deviation of multiple fields from one range. For example, the formula returns the standard deviation of heights, weights, and ages for the group "Fox" from the B7:C13 range where the field arguments are "Height", "Weight", and "Age" and the field argument is inclusively between B4:C5.


Summary

The DSTDEVP function is used to calculate the standard deviation of an entire population of data, given a database argument containing field headers, a field argument of the name or index of the field to query, and a criteria argument.

  • The DSTDEVP function calculates the standard deviation of a population of data by measuring the mean squared deviation with a subset of data.

Frequently Asked Questions

What is the DSTDEVP function?
The DSTDEVP function calculates the standard deviation of a population using all data in a population.
What type of value does the DSTDEVP function use?
The DSTDEVP function uses numbers in a field in a list or database.
What is the criteria argument?
The criteria argument specifies which range of cells to use in the function.
What type of value can be used in the criteria argument?
The criteria argument can be any range.
What must the criteria argument include?
  • The range in the criteria argument must include at least one column label.
  • The range in the criteria argument must include at least one cell below the column header.

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