DSTDEVP function in Excel

What is DSTDEVP Function in Excel?

The DSTDEVP function is one of the Database functions of Excel.

It calculates the standard deviation based on the entire population of selected database entries.

We can find this function in the Database of the insert function Tab.

How to use DSTDEVP function in excel

1. Click on an empty cell (like F5 )

2. Click on the fx icon (or press shift+F3)

3. In the insert function tab you will see all functions

4. Select Database category

5. Select DSTDEVP function

6. Then select ok

7. In the function arguments Tab you will see DSTDEVP function

8. In the Database section you can enter the range of cells that makes up the list or database. A database is a list of related data (ex: Table1)

9. Field section is either the label of the column in double quotation marks or a number that represents the column’s position in the list

10. Criteria section is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition (ex: Table1)

11. You will see the result in formula result section

Examples of DSTDEVP function in excel

Example1:

calculate STDEVP of student height with DSTDEVP function

Example 2:

calculate STDEVP of student age with DSTDEVP function

Python code for STDEVP function

import statistics

age=[25, 25, 27, 22, 29 ,29,21, 25 ,22]

stdev_age=statistics.stdev(age)

print(stdev_age)

DSTDEVP related functions :

• DCOUNT Function
• DCOUNTA Function
• DMAX Function
• DVARP Function
• DVAR Function
• DSTDEV Function