writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − + Line 13:
Line 13: −
→Description
*This function gives the sum of the difference of squares of corresponding values in <math> x </math> and <math> y </math>.
*This function gives the sum of the difference of squares of corresponding values in <math> x </math> and <math> y </math>.
*In <math> SUMX2MY2(x,y), x </math> is the first array of real values and <math> y </math> is the second array of real values.
*In <math> SUMX2MY2(x,y), x </math> is the first array of real values and <math> y </math> is the second array of real values.
*This function is defined by <math> SUMX2MY2= \sum (x^2-y^2).
*This function is defined by <math> SUMX2MY2= \sum (x^2-y^2) </math>.
*The arguments can be be either numbers or names, array,constants or references that contain numbers.
*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.
*Suppose the array contains text,logical values or empty cells, like that values are not considered.
2. The arguments containing the error values or text that cannot be translated in to numbers.
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.
3. x and y are having different number of values.
==Examples==
==Examples==