Difference between revisions of "Manuals/calci/SUMXMY2"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMXMY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - r...") |
(No difference)
|
Revision as of 20:45, 24 October 2013
SUMXMY2(ArrayX, ArrayY)
where,
ArrayX - represents the first array of values.
ArrayY - represents the second array of values.
It returns the sum of differences of corresponding values in two arrays.
Formula :-
SUMXMY2 = Σ (x - y )2
If ArrayX and ArrayY have different number of values, SUMXMY2 returns the #ERROR.
SUMXMY2
Lets see an example in (Column3, Row1)
=SUMXMY2(R1C1:R7C1,R1C2: R7C2)
SUMXMY2 returns 259.
Consider an another example
=SUMXMY2(R1C1:R7C1,R1C2: R6C2)
SUMXMY2 returns the #ERROR.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 15 | 1 | 259 | |
| Row2 | 8 | 2 | ||
| Row3 | 5 | 3 | ||
| Row4 | 1 | 4 | ||
| Row5 | 8 | 5 | ||
| Row6 | 7 | 6 | ||
| Row7 | 5 | 7 |
