Estimates the standard deviation of a population based on a sample of entries in a database that match specified conditions.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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.
=DSTDEV(A1:C10, "Sales", E1:E2)결과: 12.45
Calculates the sample standard deviation of the 'Sales' column for records matching the criteria in E1:E2.
DSTDEV calculates the sample standard deviation, while DSTDEVP calculates the standard deviation for the entire population.