### 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 30 arguments.* For the Microsoft documentation refer to support.office.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