Syntax
STDEVP(value1, [value2, ...])
| Parameter | Description |
|---|---|
| value1 | Parameter of the STDEVP function. |
| [value2 | (Optional.) Parameter of the STDEVP function. |
| ...] | Parameter of the STDEVP function. |
Examples
Population spread
Formula
=STDEVP(C2:C50)
Returns the population standard deviation for all 49 values. Identical to STDEV.P(C2:C50).
Team performance consistency
Formula
=STDEVP(B2:B12)
If B2:B12 contains every team member's performance metric, returns the exact spread. No need for sample correction since this is the whole team.
Multiple arguments
Formula
=STDEVP(10, 20, 30, 40, 50)
Returns 14.14 — the population standard deviation of these five values directly.
Common Errors
#DIV/0!
No numeric values provided.
#VALUE!
Non-numeric direct arguments.
Tips
Use STDEV.P instead
STDEVP is a compatibility function. STDEV.P is the preferred modern name but produces the same result.
Only for complete populations
Only use this when you have data for every member of the group. Sampling 100 employees out of 10,000 calls for STDEV.S, not STDEVP.
Relationship to variance
STDEVP is the square root of VARP. If you need variance instead, use VARP or VAR.P directly.
Try STDEVP in Viztab
Import your data and use STDEVP with 370+ other formulas. No signup required.
Open Viztab