Función de Google Sheets

DSTDEV

Estimates the standard deviation of a population based on a sample of entries in a database that match specified conditions.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

DSTDEV(database, field, criteria)

The DSTDEV function calculates the sample standard deviation for a specific field in a database. It only includes records that meet the criteria defined in a separate range, allowing for complex data filtering before calculation.

Argumentos

databaseobligatorioThe range of cells that makes up the list or database.
fieldobligatorioThe column label or index used in the function.
criteriaobligatorioThe range of cells that contains the specified conditions.

Ejemplos

=DSTDEV(A1:C10, "Sales", E1:E2)

Resultado: 12.45

Calculates the sample standard deviation of the 'Sales' column for records matching the criteria in E1:E2.

Preguntas frecuentes

What is the difference between DSTDEV and DSTDEVP?

DSTDEV calculates the sample standard deviation, while DSTDEVP calculates the standard deviation for the entire population.

Funciones relacionadas

STDEV DSUM DAVERAGE