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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } .
• In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUMX2MY2(x,y)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the first array of real values and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } is the second array of real values.
• This function is defined by: Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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