Excel functions / Database
DSTDEV function
The standard deviation of a column of a table for the matching rows, treating them as a sample.
Syntax
=DSTDEV(database, field, criteria)
Arguments
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1.criteria: The conditions: a range with column labels in its first row and what to match below them.
When to use it
DSTDEV gives the standard deviation of one column of a table for the matching rows, treating them as a sample. DSTDEVP treats them as the whole population.
Examples
How much North sales vary
A B C D E 1 Region 2 North 458.26 3 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DSTDEV(A4:C9, "Sales", A1:A2)→ 458.26
Common mistakes
- One matching row. A sample of one has no spread: #DIV/0!.
DSTDEV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DSMODCH.VÝBĚR
- Danish: DSTDAFV
- Dutch: DBSTDEV
- Finnish: TKESKIHAJONTA
- French: BDECARTYPE
- German: DBSTDABW
- Hungarian: AB.SZÓRÁS
- Italian: DB.DEV.ST
- Norwegian: DSTDAV
- Polish: BD.ODCH.STANDARD
- Portuguese (Brazil): BDEST
- Portuguese (Portugal): BDDESVPAD
- Russian: ДСТАНДОТКЛ
- Spanish: BDDESVEST
- Swedish: DSTDAV
- Turkish: VSEÇSTDSAPMA