Manuals/calci/SUMX2MY2
Jump to navigation
Jump to search
SUMX2MY2(ArrayX, ArrayY)
where,
ArrayX - represents the first array of values.
ArrayY - represents the second array of values.
It returns the sum of the difference of square of corresponding values in two arrays.
Formula :-
SUMX2MY2 = Σ (x2 - y2)
If ArrayX and ArrayY have different number of values, SUMX2MY2 returns the #ERROR.
SUMX2MY2
Lets see an example in (Column3, Row1)
=SUMX2MY2(R1C1:R7C1,R1C2: R7C2)
SUMX2MY2 returns 313.
Consider an another example
=SUMX2MY2(R1C1:R7C1,R1C2: R6C2)
SUMX2MY2 returns the #ERROR.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 15 | 1 | 313 | |
| Row2 | 8 | 2 | ||
| Row3 | 5 | 3 | ||
| Row4 | 1 | 4 | ||
| Row5 | 8 | 5 | ||
| Row6 | 7 | 6 | ||
| Row7 | 5 | 7 |
