Manuals/calci/SUMX2PY2

From ZCubes Wiki
Revision as of 21:45, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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