STDEV.P Function

Calculates the standard deviation of an entire population.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice STDEV.P 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

STDEV.P measures how spread out numbers are around their average when the numbers are the whole group, not a sample.

Use the .S (sample) version when your numbers are a sample of a bigger group — some customers, some days, some products — and the .P (population) version when they are the entire group you care about. The sample version divides by n − 1 instead of n, which makes it slightly larger to allow for the people you didn't measure.

In a range, text, TRUE/FALSE and empty cells are ignored. Numbers, logical values and numbers-as-text typed straight into the argument list are counted.

Syntax

=STDEV.P(number1, [number2], …)

Arguments

ArgumentRequired?What it does
number1YesA number, cell or range covering the whole population.
number2, …NoUp to 254 more numbers, cells or ranges.

Examples

Example 1 — Spread across the whole sales team

These seven reps are the entire team, so the population version fits.

E2fx=STDEV.P(C2:C8)
ABCDE
1RepRegionSalesMeasureResult
2AnaNorth62000Population9567.31
3BenSouth48500Sample10333.87
4CyNorth50000
5DiEast71250
6EdSouth39800
7FayNorth55400
8GusEast48500
=STDEV.P(C2:C8) Explain

The population figure is always a little smaller — the gap shrinks as the number of values grows.

Example 2 — Square it to get the variance

Standard deviation is the square root of variance.

=STDEV.P(C2:C8)^2 Explain

Returns about 91,533,367 — the same as VAR.P(C2:C8).

Common mistakes

  • #DIV/0! The range contains no numbers.
  • Sample or population? Mixing them up is the most common mistake. If in doubt — your data is a sample of something bigger — use the .S version.
  • Numbers stored as text. Imported values that are really text are skipped. Convert them with VALUE or Data › Text to Columns.

Notes

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.