Manuals/calci/SUMX2MY2

From ZCubes Wiki
Jump to navigation Jump to search
SUMX2MY2(x,y)


  • and are the array of values.


Description

  • This function gives the sum of the difference of squares of corresponding values in and .
  • In is the first array of real values and is the second array of real values.
  • This function is defined 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.
  • This function will give the result as error when
       1. Any one of the argument is nonnumeric or not a real number.
       2. The arguments containing the error values or text that cannot be translated in to numbers.
       3. x and y are having different number of values.

Examples

x={29,71,10,16} y={16,50,8,14} SUMX2MY2(B1:B4,C1:C4) = null


See Also


References