Manuals/calci/SUMX2MY2

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 } 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 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 $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), 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 <math> 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 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

x={29,71,10,16} y={16,50,8,14} SUMX2MY2(B1:B4,C1:C4) = null

See Also

• SUMX2PY2
• SUMXMY2
• SUMPRODUCT