Learn Excel - Simplify Life with Excel Concepts

## Excel DSTDEVP Function

### How to use the DSTDEVP Function

This Excel tutorial explains how to use the Excel DSTDEVP function with syntax and examples.

### SUMMARY:

The Excel DSTDEVP function returns the standard deviation of a population based on the entire population column values of datatable or database, based on a given conditions.

For example,

• The formula =DSTDEVP(D7:G12,"Price",D4:E5) would return 75 numeric value.
• The formula =DSTDEVP(D7:G12,2,D4:E5) would return 75 numeric value.

### PURPOSE:

To Get the standard deviation of a population based on the entire population based on given Criteria.

### RETURN VALUE:

The DSTDEVP function returns a Numeric value.

### SYNTAX:

=DSTDEVP(database, field, criteria)

### ARGUMENTS:

The DSTDEVP function syntax has the following arguments:

• database: Required. The range of cells that makes up the list or database including data headers.
• field: Required. The table header name or index number of header.
• criteria: Required. The range of cells that contains your criteria including data headers.

### REMARKS:

• The database argument is a range of cells that includes field headers.
• The criteria can include a variety of expressions, including some wildcards.
• The DSTDEVP function supports wildcards in criteria.
• The Criteria can include more than one row.
• Make sure that the criteria range does not overlap the database list.
• The database and criteria ranges must include matching headers.

Useful Links: Link 1Link 2Link 3Link 4