DEVSQ

DEVSQ(number1 [,number2] [..])

Returns the sum of the squared deviations from the mean.

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

REMARKS

* This function is sometimes referred to as the Deviation Squares function.
* The arguments must be numbers, or names, arrays, or references that contain numbers.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* This function can return large values when you have a large number of arguments.
* The Variance is the value returned from this function divided by the number of arguments.
* The value returned is often called the pooled standard deviation.
* You can have a maximum of 255 arguments.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=DEVSQ(1, 2, 3, 4, 5) = 10
2	=((3-1)(3-1))+((3-2)(3-2))+0+((4-3)(4-3))+((5-3)(5-3)) = 10
3	=DEVSQ(1, 2, 3, 4, 5)/5 = 2
4	=VARP(1, 2, 3, 4, 5) = 2