Google Sheets işlevi

DSTDEV

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

Yapay zekâ ile formül oluştur Excel'deki aynı işlev

Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.

Söz dizimi

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.

Bağımsız değişkenler

databasezorunluThe range of cells that makes up the list or database.
fieldzorunluThe column label or index used in the function.
criteriazorunluThe range of cells that contains the specified conditions.

Örnekler

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

Sonuç: 12.45

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

SSS

What is the difference between DSTDEV and DSTDEVP?

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

İlgili işlevler

STDEV DSUM DAVERAGE