STDEVP
The pre-2010 name for STDEV.P. Same calculation, same result; kept so older workbooks open unchanged.
Syntax
STDEVP(number1, [number2], ...)| Argument | Required | Description |
|---|---|---|
number1 | Required | A range or value. |
number2 | Optional | Further ranges or values. |
Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=STDEVP(A2:A9) | 2 | |
=STDEVP(A2:A9)=STDEV.P(A2:A9) | TRUE | Identical to STDEV.P. |
Prefer STDEV.P in new work
STDEVP is the name Excel used before 2010, when the statistical functions were
split into explicitly named sample and population versions. Both names work and always agree, and
STDEVP is kept so older workbooks recalculate unchanged.
In a new sheet, STDEV.P says what it computes. With the old
names, the only way to tell the population version from the sample one is to remember which has the P.
Excel compatibility
Matches Excel.