Manuals/calci/SUMX2PY2

SUMX2PY2(x,y)


  • and are the array of values.

Description

  • This function gives the sum of the sum of squares of corresponding values in   and  .
  • In  ,   is the first array of real values and   is the second array of real values.
  • It is mostly common term in statistical calculations.
  • 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.   and   are having different number of values.

Examples

Spreadsheet
A B C D E
1 25.5 34.2 67.9 12 10
2 12.56 40.45 12.98 15 17
3 0 5 7 9 18
4 12 22 31 16 26
  1. =SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
  2. =SUMX2PY2(A3:E3,A4:E4) = 3000
  3. =SUMX2PY2([10,20,30],[5,15,25]) = 2275

Related Videos

SUMPRODUCT

See Also

References