Difference between revisions of "Manuals/calci/SUMSQ"

From ZCubes Wiki
Jump to navigation Jump to search
Line 33: Line 33:
 
==References==
 
==References==
 
*[http://www.excelfunctions.net/Excel-Sumsq-Function.html Sum of Squares]
 
*[http://www.excelfunctions.net/Excel-Sumsq-Function.html Sum of Squares]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Revision as of 06:24, 13 March 2017

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

  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") = Null
  7. =SUMSQ(2+3I,4+5I) = 106

Related Videos

SUMSQ

See Also

References