The STDEV.P function
Returns the standard deviation of a whole population, for when your data is every value there is and not a sample.
Syntax
STDEV.P(number1, [number2], ...)- number1
- The first number or range in the population.
- number2, ... (optional)
- More numbers or ranges, up to 255 in all.
Examples
D1=STDEV.P(B2:B6)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Day | Sales | 20.59126028 | |
| 2 | Mon | 120 | ||
| 3 | Tue | 95 | ||
| 4 | Wed | 140 | ||
| 5 | Thu | 110 | ||
| 6 | Fri | 80 |
B1=STDEV.P(2,4,4,4,5,5,7,9)
| A | B | |
|---|---|---|
| 1 | 2 |
Questions
Why is STDEV.P smaller than STDEV.S on the same data?
STDEV.P divides by the number of values, STDEV.S by one less. The difference is large for a handful of values and shrinks as the data grows.
Is STDEV.P the same as STDEVP?
Yes. STDEVP is the older name and gives the same result.