STDEV.P()/STDEVP()

Syntax. STDEV.P(number1,number2,...)

Definition. This function calculates the standard deviation based on the population. All values have to be specified as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Arguments

  • number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas. Logical values (TRUE and FALSE) and text are ignored. If you want to include logical values and text in the calculation, use the STDEVA.P() function.

Note

The STDEV.P() function assumes that its arguments ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.