Microsoft Office Tutorials and References
In Depth Information
SUMX2MY2
SUMX2MY2
The SUMX2MY2 function returns the sum of the difference of squares of corresponding values in
two arrays. Therefore, the order that you enter the arguments into this function is important.
=SUMX2MY2(x, y)
If an ARRAY or REFERENCE argument contains text, logical values, or empty cells, those values
are ignored; however, cells with the value zero are included. If the x and y arrays are
different sizes, SUMX2PY2 returns an error value.
For example: =SUMX2MY2(3, 2) equals 5, whereas =SUMX2MY2(2, 3) equals –5.
The X argument is the first array or range of values.
X
The Y argument is the second array or range of values. The
arguments can be numbers or names, arrays, or references that
contain numbers.
Y
SUMX2PY2
The SUMX2PY2 function returns the sum of the sum of squares of corresponding values in two
arrays.
=SUMX2PY2(x, y)
If an ARRAY or REFERENCE argument contains text, logical values, or empty cells, those values
are ignored; however, cells with the value zero are included. If the x and y arrays are
different sizes, SUMX2PY2 returns an error value. For example: SUMX2PY2(2, 3) equals 13.
The X argument is the first array or range of values.
X
The Y argument is the second array or range of values. The
arguments can be numbers or names, arrays, or references that
contain numbers.
Y
SUMXMY2
The SUMXMY2 function returns the sum of squares of differences of corresponding values in
two arrays.
=SUMXMY2(x, y)
If an array or reference argument contains text, logical values, or empty cells, those values
are ignored; however, cells with the value zero are included. If x and y have a different
number of values, SUMXMY2 returns an error value. For example: SUMXMY2({2,3}, {3,4}) equals 2.
The X argument is the first array or range of values.
X
The Y argument is the second array or range of values and the
arguments can be numbers or names, arrays, or references that
contain numbers.
Y
Search JabSto ::

Custom Search