DSTDEV Function

The DSTDEV function is used to calculate the Standard Deviation based on a sample, by using the numbers in a column in a table/database that matches the conditions given.
Note: Standard Deviation is a measure that shows how much variation of values exists from the average (mean).

Formula:


=DSTDEV(Database Range, Field Name, Criteria Range)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field whose variance has to be found and CriteriaRange is the name of the FieldName

Video Tutorial:


Let us find the standard deviation based on a sample, using the DSTDEV function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question