Functions
STDEV.P
Population standard deviation
Try it
When to use it
When should I use STDEV.P instead of STDEV.S?
Use STDEV.P when your data represents the entire population, not a sample; it divides by N rather than N-1 and produces a smaller value that reflects the true population spread.
Used in
Syntax
STDEV.P(value1,...)Examples
=STDEV.P(1,2,3,4,5,6,7,8,9,10) // => 2.8722813232690143