DSTDEVP Function in Google Sheets

Estimate the standard deviation of an entire population from a database that meets specified criteria using the DSTDEVP function.

DSTDEVP Function

The DSTDEVP function in Google Sheets estimates the standard deviation of an entire population from a specified field of a database that meets given criteria.

Syntax

DSTDEVP(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name containing the values to evaluate.
  • criteria: The range of cells that contain the conditions for estimating the standard deviation.

Examples

  1. Basic Example

Estimate the standard deviation of values in field 2 of the database A1:C10 where criteria are in E1:E2:

=DSTDEVP(A1:C10, 2, E1:E2)
  1. Using Header Names

Estimate the standard deviation of values in the ‘Grades’ column where criteria are in G1:G2:

=DSTDEVP(A1:C10, "Grades", G1:G2)

Notes

  • Useful for understanding variability in the entire dataset.
  • DSTDEV: Estimate the standard deviation of a sample.
  • DAVERAGE: Calculate the average of values meeting criteria.