Manuals/calci/SUMXMY2

SUMXMY2(x,y)

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

Description

• This function gives the sum of squares of differences of corresponding values in $x$ and $y$.
• In $SUMXMY2(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: $SUMXMY2=\sum (x-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	E
1	80.16	78.42	65.21	12	10
2	65.9	59.80	45.12	15	17
3	0	9	18	27	36
4	8	18	29	37	45

1. =SUMXMY2(A1:C1, A2:C2) = 953.660099999
2. =SUMXMY2(A3:E3,A4:E4) = 447
3. =SUMXMY2([10,13,17,19,23],[7,9,19,31,37]) = 369

Related Videos

SUMPRODUCT

See Also

• SUMX2PY2
• SUMX2MY2
• SUMPRODUCT

References

• Sum of the Squares of the differences