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