Manuals/calci/SUMX2MY2

SUMX2MY2(x,y)

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

Description

• This function gives the sum of the difference of squares of corresponding values in $x$ and $y$.
• In $SUMX2MY2(x,y)$, $x$ is the first array of real values and $y$ is the second array of real values.
• This function is defined by: $SUMX2MY2=\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 non-numeric 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
1	29	71	10	16
2	16	50	8	14

=SUMX2MY2(A1:D1,A2:D2) = 3222

Spreadsheet

	A	B	C	D	E
1	45	-12	14	-7	23.3
2	-18	41.7	-20	34	10

=SUMX2MY2(A1:E1,A2:E2) = -762.0000000000003

Related Videos

SUMPRODUCT

See Also

• SUMX2PY2
• SUMXMY2
• SUMPRODUCT

References

• Sum of Difference of Squares