Manuals/calci/SUMX2PY2

SUMX2PY2(x,y)

• $x$ and $y$ are the array of values.

Description

• This function gives the sum of the sum of squares of corresponding values in $x$ and $y$.
• In $SUMX2PY2(x,y)$, $x$ is the first array of real values and $y$ is the second array of real values.
• It is mostly common term in statistical calculations.
• This function is defined by :

$SUMX2PY2=\sum (x^{2}+y^{2})$.

• 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

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

See Also

• SUMX2MY2
• SUMXMY2
• SUMPRODUCT

References

• [http://www.techonthenet.com/excel/formulas/sumx2py2.php