# STDEV.P

STDEV.P(number1 [,number2] [..])

Returns the standard deviation based on an entire population.

 number1 The first number. number2 (Optional) The second number.

 REMARKS
 * This function was added in Excel 2010 to replace the STDEVP function.* The standard deviation is a measure of how [[Dispersed]] the values are from the mean.* Arguments that are text or logical values are ignored.* You can also use a single array or a reference to an array instead of arguments separated by commas.* You can have a maximum of 255 arguments.* You can use the STDEVPA function to return the standard deviation based on an entire population (including logical values and text).* You can use the STDEV.S function to return the standard deviation based on a sample.* You can use the STDEVA function to return the standard deviation based on a sample (including logical values and text).* For the Microsoft documentation refer to support.microsoft.com

 A 1 =STDEV.P(10, 20, 30, 40) = 11.180

 1 - What is the standard deviation of 10,20,30,40.