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

Returns the variation of a data set from its mean.

number1The first number.
number2The second number.
number3(Optional) The third number.

* 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
* For the Google documentation refer to

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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top