Difference between revisions of "Manuals/calci/SUMSQ"
Jump to navigation
Jump to search
Line 20: | Line 20: | ||
#=SUMSQ(0,10,20,30,40) = 3000 | #=SUMSQ(0,10,20,30,40) = 3000 | ||
#=SUMSQ(-1,-2,-3,-4,-5) = 55 | #=SUMSQ(-1,-2,-3,-4,-5) = 55 | ||
− | #=SUMSQ("2+3i","4+5i") = | + | #=SUMSQ("2+3i","4+5i") = 0 |
#=SUMSQ(2+3I,4+5I) = 106 | #=SUMSQ(2+3I,4+5I) = 106 | ||
Revision as of 14:14, 16 March 2018
SUMSQ(n1,n2,n3,…)
- are numbers.
Description
- This function gives the sum of the squares of the arguments.
- In , , 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: .
- 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
- =SUMSQ(5,10) = 125
- =SUMSQ(2,7,11) = 174
- =SUMSQ(44) = 1936
- =SUMSQ(0,10,20,30,40) = 3000
- =SUMSQ(-1,-2,-3,-4,-5) = 55
- =SUMSQ("2+3i","4+5i") = 0
- =SUMSQ(2+3I,4+5I) = 106
Related Videos
See Also
References