SheetFX
≡
<< Go back to all functions

DSTDEV

The DSTDEV function in Google Sheets is a powerful tool to calculate the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Whether you're analyzing survey data, financial records, or any other large dataset, the DSTDEV function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: DSTDEV(database, field, criteria)

Parameters:

  • database: The range or array containing the database table-like data.
  • field: The column or field to consider for the standard deviation calculation.
  • criteria: A string containing the SQL-like query to select the population sample.

Step-by-Step Tutorial

  1. Using DSTDEV with a database array:

    • Example: =DSTDEV(A2:D10, "B", "A='Category1'")
    • Result: Returns the standard deviation of values in column B for rows where column A is 'Category1'.

  2. Using DSTDEV with a database range and column indices:

    • Example: =DSTDEV(A2:D10, 2, "A='Category1'")
    • Result: Returns the standard deviation of values in the second column (B) for rows where column A is 'Category1'.

  3. Using DSTDEV with multiple criteria:

    • Example: =DSTDEV(A2:D10, "B", "A='Category1' AND C>10")
    • Result: Returns the standard deviation of values in column B for rows where column A is 'Category1' and column C is greater than 10.

Use Cases and Scenarios

  1. Survey Analysis: Calculate the standard deviation of responses for specific survey categories.
  2. Financial Risk Assessment: Determine the variability in investment returns for different asset classes.
  3. Quality Control: Assess the consistency of measurements in a production process.

Related Functions

  • STDEV: Find the standard deviation of a sample from a set.
  • DSTDEVP: Calculate the standard deviation of a population from a database table-like array or range.

Related Articles