Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
STDEVPA
Calculates population standard deviation, counting text as 0 and TRUE as 1.
Rarely usedDifficulty 1250 · ProficientUsage rank #291 of 520
When to use it
Population standard deviation that counts text as 0 and logicals as 1 or 0.
The shape of it
- Syntax
=STDEVPA(value1, [value2], ...)
Worked examples
Plain numbers
=STDEVPA(2,4,4,4,5,5,7,9) → 2
Same as STDEV.P on plain numbers.
With a logical
=STDEVPA(1,2,TRUE) → 0.471404521
Population sd of 1, 2, 1.
With text
=STDEVPA(A2:A4) → 4.714045208
10, 0, and text as 0.
Worth knowing
- Use only for full populations with placeholders that should be zero.
- STDEV.P is the normal choice.
- Blanks are ignored.
Where it goes wrong
- Text as 0 distorts the result.
- Numbers stored as text count as 0.
Related
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.