Estimates the standard deviation of a population based on a sample of entries in a database that match specified conditions.
תחביר
DSTDEV(database, field, criteria)ארגומנטים
databaseחובה
The range of cells that makes up the list or database.
fieldחובה
The column label or index used in the function.
criteriaחובה
The range of cells that contains the specified conditions.
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.
=DSTDEV(A1:C10, "Sales", E1:E2)→12.45Calculates the sample standard deviation of the 'Sales' column for records matching the criteria in E1:E2.
Prepare the database
Ensure your data is organized in a table with headers for each column.
Define criteria
Create a separate range containing the column header and the condition to filter by.
Apply the function
Enter the DSTDEV function referencing your database, the target field, and the criteria range.
DSTDEV calculates the sample standard deviation, while DSTDEVP calculates the standard deviation for the entire population.