DSTDEVP Function

Calculates the standard deviation of matching records, treating them as the whole population.

Category

Database

Available in

All versions, Microsoft 365

Returns

A number

Want to practice DSTDEVP in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

DSTDEVP measures the spread of the field values when the matching records are the entire population (it divides by n, like STDEV.P).

Its answer is always a little smaller than DSTDEV's for the same records.

Syntax

=DSTDEVP(database, field, criteria) Explain

Arguments

ArgumentRequired?What it does
databaseYesThe whole list, including the header row — e.g. A1:E7. Each row is a record, each column a field.
fieldYesWhich column to calculate: its header in quotes ("Sales"), a cell holding the header, or its position (5 = the fifth column).
criteriaYesA small range with at least one header copied exactly from the list and the conditions underneath, e.g. G1:G2.

Examples

Example 1 — Spread of every Paper sale

These three are all the Paper orders there are, so treat them as the population.

G5fx=DSTDEVP(A1:E7,"Sales",G1:G2)
ABCDEFG
1RegionRepProductUnitsSalesProduct
2NorthAmaraPaper40520Paper
3SouthBenToner12576
4NorthChloeToner8384Std dev (pop.)
5EastDevPaper2532581.07
6NorthAmaraPens100120
7SouthEllaPaper30390
=DSTDEVP(A1:E7,"Sales",G1:G2) Explain

Common mistakes

  • Sample or population? If the records are a sample used to judge a bigger group, use DSTDEV instead.

Notes

  • Criteria rules: conditions on the same row must all be true (AND); conditions on separate rows are alternatives (OR). Text such as Nor matches anything that begins with it — type ="=North" for an exact match. Use >500, <>East, or wildcards like *Paper*.
  • Related functions: DSUM, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVARP.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.