Manuals/calci/SUMSQ

SUMSQ()

• Parameters are any set of numbers.
• SUMSQ(), returns the sum of the squares of the arguments.

Description

• This function gives the sum of the squares of the arguments.
• In , Parameters are any real numbers.
• This function is finding the squares of the numbers and it is adding all the numbers together. Instead of numbers, we can use the single array or a reference to an array.
• This function is calculated by: ,where are set of parameters.
• The arguments can be be either numbers or names, array, constants or references that contain numbers.
• Suppose the array contains text,logical values or empty cells, like that values are not considered.
• Also numbers,logical values and text representations of numbers when we entering directly in to the list of the arguments then it is countable.
• This function will give the result as error when
1. Any one of the argument is non-numeric or not a real number.
2. The arguments containing the error values or text that cannot be translated in to numbers.

Examples

1. =SUMSQ(5,10) = 125
2. =SUMSQ(2,7,11) = 174
3. =SUMSQ(44) = 1936
4. =SUMSQ(0,10,20,30,40) = 3000
5. =SUMSQ(-1,-2,-3,-4,-5) = 55
6. =SUMSQ("2+3i","4+5i") = 0
7. =SUMSQ(2+3I,4+5I) = 106

SUMSQ