STDEVP

Try it

When to use it

When should I use STDEVP?

Use STDEVP (legacy alias for STDEV.P) when working with older spreadsheet files or formulas; it computes population standard deviation and ignores text and logical values.

Used in

science · operations

Syntax

STDEVP(value1,...)

Examples

=STDEVP(1,2,3,4,5,6,7,8,9,10) // => 2.8722813232690143