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 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