DSTDEVP Function

The DSTDEVP function is used to calculate the Standard Deviation based on the entire population by using the numbers in the column in the table/database that matches the conditions mentioned.

Formula:


=DSTDEVP(Database Range, Field Name, Criteria Range)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field whose standard deviation has to be found and CriteriaRange is the conditions mentioned.

Video Tutorial:


Let us find the standard deviation based on the entire population, using the DSTDEVP function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question