# 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* For the Google documentation refer to support.google.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

© 2024 Better Solutions Limited