STDEVPA

STDEVPA(value1 [,value2] [..])

Returns the standard deviation based on an entire population (including logical values and text).

value1	The first value.
value2	(Optional) The second value.

REMARKS

* This function is identical to the STDEV.P function except that logical values, text and errors are included.
* The standard deviation is a measure of how Dispersed the values are from the mean.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
* Arguments that are text or logical values are ignored.
* You can have a maximum of 255 arguments.
* You can use the STDEV.P function to return the standard deviation based on an entire population.
* 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	=STDEVPA(10, 20, 30, 40) = 11.180

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