# SUMSQ

SUMSQ(number1, number2 [,number3] [..])

Returns the variation of a data set from its mean.

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

 REMARKS
 * The sum of squares is a value used in regression analysis to indicate the dispersion of data points.* This measures the deviation of the data points away from the mean.* The higher the value, the further away the data points are from the mean.* The lower the value, the closer the data points are from the mean.* The arguments can be numbers, arrays, names or cell references that contain numbers.* 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 AVERAGE function to return the arithmetic mean of the values in a list, table or cell range.* You can use the MODE.SNGL function to return the first number that appears the most often in a set.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =SUMSQ(1, 1) = 2 2 =SUMSQ(2, 2) = 8 3 =SUMSQ(3, 4) = 25 4 =SUMSQ(12, 4) = 160 5 =SUMSQ(5, 10) = 125 6 {=SUM({1,2,3,4}^2)} = 30 7 {=SUM({1,2}*{3,4})} = 11