Wauvel

Excel like a finance pro.

← The library

Compatibility function

STDEVP

Calculates standard deviation of an entire population; replaced by STDEV.P.

OccasionalDifficulty 1200 · ProficientUsage rank #204 of 520
Practice · 3 questions →

When to use it

Population standard deviation. Replaced by STDEV.P.

The shape of it

Syntax
=STDEVP(number1, [number2], ...)

Worked examples

  • Eight values

    =STDEVP(2,4,4,4,5,5,7,9) → 2

    The shared eight values.

  • Ten measurements

    =STDEVP(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299) → 26.05456

    Ten measurements as a population.

  • Every store

    =STDEVP(A2:A51) → 0.85

    Every store.

Worth knowing

  • STDEV.P is identical.
  • Only for whole populations.
  • Slightly smaller than STDEV.

Where it goes wrong

  • Understates spread on samples.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.