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

* The standard deviation is a measure of how Dispersed the values are from the mean.
* Arguments that are cell ranges containing zeros are included.
* Arguments that are cell ranges containing dates are included.
* Arguments that are cell ranges containing hidden cells are included.
* Arguments that are cell ranges containing error values are excluded.
* Arguments that are cell ranges containing logical values are excluded.
* Arguments that are cell ranges containing text are excluded.
* Arguments that are cell ranges containing empty cells are excluded.
* 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).
* You can use the AGGREGATE and SUBTOTAL functions to return the standard deviation based on an entire population.
* This function was added in Excel 2010 to replace the STDEVP function.
* 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.