Difference between revisions of "Manuals/calci/SUMX2PY2"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ...")
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''SUMX2PY2(x,y)'''</div><br/>
 +
*<math> x </math> and <math> y </math>  are the array of values.
  
'''SUMX2PY2'''(ArrayX, ArrayY)
+
==Description==
 +
*This function gives the sum of the sum of squares of corresponding values in  <math> x </math> and  <math> y </math>. 
 +
*In <math> SUMX2PY2(x,y)</math>, <math>x </math> is the first array of real values and <math> y </math> is the second array of real values.
 +
*It is  mostly common term in statistical calculations.
 +
*This  function is defined by : 
 +
<math> SUMX2PY2= \sum (x^2+y^2) </math>.
 +
*The arguments can be be either numbers or names, array,constants or references that contain numbers.
 +
*Suppose the array contains text,logical values or empty cells, like that values are not considered.
 +
*This function will give the result as error when
 +
      1. Any one of the argument is nonnumeric or not a real number.
 +
      2. The arguments containing the error values or text that cannot be translated in to numbers.
 +
      3. <math>x</math> and <math>y</math> are having different number of values.
  
where,
+
==Examples==
  
'''ArrayX''' - represents the first array of values.
+
{| class="wikitable"
 
+
|+Spreadsheet
'''ArrayY''' - represents the second array of values.
+
|-
 
+
! !! A !! B !! C !! D!! E
</div>
+
|-
----
+
! 1
<div id="1SpaceContent" class="zcontent" align="left">
+
| 25.5 || 34.2 || 67.9 || 12 || 10
 
+
|-
It returns the sum of the sum of square of corresponding values in two arrays.
+
! 2
 
+
| 12.56 || 40.45 || 12.98 || 15 ||17
'''Formula''' :-
+
|-
 
+
! 3
SUMX2PY2 = Σ (x<sup>2</sup> + y<sup>2</sup>)
+
| 0  || 5  || 7  ||9 || 18
 
+
|-
</div>
+
!4
----
+
| 12 || 22 || 31 || 16 || 26
<div id="7SpaceContent" class="zcontent" align="left">
+
|}
 
 
If ArrayX and ArrayY have different number of values, SUMX2PY2 returns the #ERROR.
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
SUMX2PY2
 
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
 
 
Lets see an example in (Column3, Row1)
 
 
 
<nowiki>=SUMX2PY2(R1C1:R7C1,R1C2: R7C2)</nowiki>
 
 
 
SUMX2PY2 returns 593.
 
 
 
Consider an another example
 
  
<nowiki>=SUMX2PY2(R1C1:R7C1,R1C2: R6C2)</nowiki>
+
#=SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
 +
#=SUMX2PY2(A3:E3,A4:E4) = 3000
 +
#=SUMX2PY2([10,20,30],[5,15,25]) = 2275
  
SUMX2PY2 returns the #ERROR.
+
==Related Videos==
  
</div>
+
{{#ev:youtube|rwsX1KVhEnU|280|center|SUMPRODUCT}}
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left">
 
  
{| id="TABLE3" class="SpreadSheet blue"
+
==See Also==
|- class="even"
+
*[[Manuals/calci/SUMX2MY2 | SUMX2MY2]]
| class=" " |
+
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]]
| class="      " | Column1
+
*[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
| class="  " | Column2
 
| class="  " | Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | 15
 
| class="                                    sshl_f " | 1
 
| class="sshl_f" | 593
 
|
 
|- class="even"
 
| class=" " | Row2
 
| class=" " | 8
 
| class=" " | 2
 
| class="    SelectTD ChangeBGColor SelectTD" |
 
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
|
 
|- class="odd"
 
| Row3
 
| class=" " | 5
 
| class=" " | 3
 
|
 
|
 
|- class="even"
 
| Row4
 
| class=" " | 1
 
| class=" " | 4
 
|
 
|
 
|- class="odd"
 
| class=" " | Row5
 
| class=" " | 8
 
| class=" " | 5
 
|
 
|
 
|- class="even"
 
| class="sshl_f" | Row6
 
| class=" " | 7
 
| class=" " | 6
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| class="sshl_f" | Row7
 
| class=" " | 5
 
| class=" " | 7
 
|
 
|
 
|}
 
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
==References==
----
+
*[http://www.techonthenet.com/excel/formulas/sumx2py2.php sum of the sum of squares]

Latest revision as of 15:11, 26 June 2015

SUMX2PY2(x,y)


  • and are the array of values.

Description

  • This function gives the sum of the sum of squares of corresponding values in and .
  • In , is the first array of real values and is the second array of real values.
  • It is mostly common term in statistical calculations.
  • This function is defined by :

.

  • The arguments can be be either numbers or names, array,constants or references that contain numbers.
  • Suppose the array contains text,logical values or empty cells, like that values are not considered.
  • This function will give the result as error when
      1. Any one of the argument is nonnumeric or not a real number. 
      2. The arguments containing the error values or text that cannot be translated in to numbers.
      3.  and  are having different number of values.

Examples

Spreadsheet
A B C D E
1 25.5 34.2 67.9 12 10
2 12.56 40.45 12.98 15 17
3 0 5 7 9 18
4 12 22 31 16 26
  1. =SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
  2. =SUMX2PY2(A3:E3,A4:E4) = 3000
  3. =SUMX2PY2([10,20,30],[5,15,25]) = 2275

Related Videos

SUMPRODUCT

See Also

References