Statistical

STDEV.P Function in Excel

Calculates standard deviation based on the entire population.

Syntax

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

Arguments

  • number1 (required): First value or range
  • number2 (optional): Additional values or ranges

Examples

  • =STDEV.P(A1:A100) - Population std dev - Result: Standard deviation

Excel STDEV.P function documentation

  • STDEV.P calculates standard deviation treating the data as an entire population.
  • Syntax: =STDEV.P(number1, [number2], ...). Use when data is the full population, not a sample.
  • Related: [STDEV.S](/functions/stdev-s/), [VAR.P](/functions/var-p/), [AVERAGE](/functions/average/).

STDEV.P vs STDEV.S

  • STDEV.P — divide by n (population).
  • STDEV.S — divide by n-1 (sample estimate).
  • Wrong choice biases risk models — document which you use.
  • Text and logical ignored; text numbers may coerce.

Step-by-step: population volatility of returns

  • Step 1 — Full history of monthly returns in B2:B120 (complete population).
  • Step 2 — =STDEV.P(B2:B120).
  • Step 3 — Annualize if needed: =STDEV.P(B2:B120)*SQRT(12).
  • Step 4 — Compare STDEV.S if history is sample of longer process.
  • Step 5 — Pair with [AVERAGE](/functions/average/) for mean return.

STDEV.P in quality and finance

  • QC — all units produced today = population.
  • Finance — often sample (STDEV.S) for forecast uncertainty.
  • Pivot — review stdev in pivot for exploratory stats.
  • Statistical hub: [/categories/statistical/](/categories/statistical/).

Worked examples to copy

  • Range: =STDEV.P(A2:A100).
  • Multiple areas: =STDEV.P(A2:A50, C2:C50).
  • With IF array legacy: avoid — use FILTER then STDEV.P.
  • 365: =STDEV.P(FILTER(B:B, B:B<>"")).

People also ask

  • STDEV.P vs STDEV? — STDEV is old sample stdev; use STDEV.S in modern Excel.
  • STDEV.P blank cells? — Ignored.
  • STDEV.P one value? — Returns 0.
  • STDEV.P Google Sheets? — STDEVP in some versions; check local name.

Common errors

  • Use when data represents entire population

Use cases

  • Quality control
  • Process variation
  • Population analysis

Frequently asked questions

  • When should I use STDEV.P vs STDEV.S? Use STDEV.P when your data IS the entire population (all students in a class, all products in inventory). Use STDEV.S when your data is a SAMPLE of a larger population (survey respondents representing all customers). STDEV.S divides by n-1 for unbiased estimation.
  • What does standard deviation tell me? Standard deviation measures how spread out values are from the average. Low StdDev = values clustered near mean. High StdDev = values spread widely. In a normal distribution, ~68% of values fall within 1 StdDev of the mean, ~95% within 2 StdDev.
  • How do I calculate coefficient of variation? CV = StdDev / Mean × 100%. In Excel: =STDEV.P(A1:A100)/AVERAGE(A1:A100)*100. CV allows comparing variability between datasets with different units or scales.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use STDEV.P

  • Quality control — common Statistical scenario for STDEV.P.
  • Process variation — common Statistical scenario for STDEV.P.
  • Population analysis — common Statistical scenario for STDEV.P.

STDEV.P in the Statistical category

  • Browse all Statistical functions at /categories/statistical/ for related formulas.
  • STDEV.P syntax: =STDEV.P(number1, [number2], ...)
  • number1 (required): First value or range
  • number2 (optional): Additional values or ranges
  • Confirm STDEV.P arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm STDEV.P arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • STDEV.S (/functions/stdev-s/): Estimates standard deviation based on a sample.
  • VAR.P (/functions/var-p/): Calculates variance based on the entire population.
  • AVERAGE (/functions/average/): Returns the average (arithmetic mean) of the arguments.

Errors to watch for

  • Use when data represents entire population — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter STDEV.P on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

STDEV.P worked examples to copy

  • =STDEV.P(A1:A100) — Population std dev. Expected result: Standard deviation.

STDEV.P reference summary for crawlers and offline review

  • STDEV.P belongs to the Statistical category in Excel. Calculates standard deviation based on the entire population.
  • Full syntax: =STDEV.P(number1, [number2], ...). Open /functions/stdev-p/ for parameters, FAQs, and related pages.
  • Common mistakes: Use when data represents entire population
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.