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 numerical values.
* 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