Manuals/calci/SUMX2PY2 - Revision history

Swapna at 20:11, 26 June 2015

2015-06-26T20:11:25Z

Devika: /* References */

2015-05-14T19:11:42Z

References

Devika: /* References */

2015-05-14T19:10:40Z

References

Abin at 11:38, 30 January 2014

2014-01-30T11:38:51Z

Devika at 05:07, 27 January 2014

2014-01-27T05:07:41Z

Devika at 05:05, 27 January 2014

2014-01-27T05:05:51Z

MassBot1: Created page with "
'''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ..."

2013-10-25T02:45:33Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''SUMX2PY2'''(ArrayX, ArrayY)

where,

'''ArrayX''' - represents the first array of values.

'''ArrayY''' - represents the second array of values.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

It returns the sum of the sum of square of corresponding values in two arrays.

'''Formula''' :-

SUMX2PY2 = Σ (x<sup>2</sup> + y<sup>2</sup>)

</div>
----
<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 returns the #ERROR.

</div>
----
<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"
|- class="even"
| class=" " |
| class=" " | Column1
| 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>
----

@@ Line 38: / Line 38: @@
 #=SUMX2PY2(A3:E3,A4:E4) = 3000
 #=SUMX2PY2([10,20,30],[5,15,25]) = 2275
 ==See Also==

← Older revision		Revision as of 19:11, 14 May 2015
Line 45:		Line 45:

	==References==		==References==
−	*[http://www.techonthenet.com/excel/formulas/sumx2py2.php	+	*[http://www.techonthenet.com/excel/formulas/sumx2py2.php sum of the sum of squares]

← Older revision		Revision as of 19:10, 14 May 2015
Line 45:		Line 45:

	==References==		==References==
		+	*[http://www.techonthenet.com/excel/formulas/sumx2py2.php

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''SUMX2PY2(x,y)'''</div><br/>
 *<math> x </math> and <math> y </math>  are the array of values.
 ==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) ,x </math> is the first array of real values and <math> y </math> is the second array of real values.
+*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>.
+*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.
@@ Line 13: / Line 13: @@
 . Any one of the argument is nonnumeric or not a real number.
 . The arguments containing the error values or text that cannot be translated in to numbers.
-. x and y are having different number of values.
+. <math>x</math> and <math>y</math> are having different number of values.
 ==Examples==
@@ Line 36: / Line 35: @@
 |}
-#SUMX2PY2(A1:C1,A2:C2)=8392.736500000003
+#=SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
-#SUMX2PY2(A3:E3,A4:E4)=3000
+#=SUMX2PY2(A3:E3,A4:E4) = 3000
-#SUMX2PY2([10,20,30],[5,15,25])=2275
+#=SUMX2PY2([10,20,30],[5,15,25]) = 2275
 ==See Also==
@@ Line 45: / Line 43: @@
 *[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
 *[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
 ==References==

@@ Line 7: / Line 7: @@
 *In <math> SUMX2PY2(x,y) ,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>.
+*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.
@@ Line 21: / Line 21: @@
 |+Spreadsheet
 |-
-! !! A !! B !! C !! D!! E !!F
+! !! A !! B !! C !! D!! E
 |-
 ! 1
@@ Line 42: / Line 42: @@
 ==See Also==
-*[[Manuals/calci/SUMX2PY2 | SUMX2PY2]]
+*[[Manuals/calci/SUMX2MY2 | SUMX2MY2]]
 *[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
 *[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:30px">'''SUMX2PY2(x,y)'''</div><br/>
-where,
+==Description==
-'''ArrayY''' - represents the second array of values.
+==Examples==
-</div>
+{| class="wikitable"
-----
+|+Spreadsheet
-<div id="1SpaceContent" class="zcontent" align="left">
+|-
+! !! A !! B !! C !! D!! E !!F
-It returns the sum of the sum of square of corresponding values in two arrays.
+|-
+! 1
-'''Formula''' :-
+| 25.5 || 34.2 || 67.9 || 12 || 10
+|-
-SUMX2PY2 = Σ (x<sup>2</sup> + y<sup>2</sup>)
+! 2
+| 12.56 || 40.45 || 12.98 || 15 ||17
-</div>
+|-
-----
+! 3
-<div id="7SpaceContent" class="zcontent" align="left">
+| 0  || 5  || 7  ||9 || 18
+|-
-If ArrayX and ArrayY have different number of values, SUMX2PY2 returns the #ERROR.
+!4
+| 12 || 22 || 31 || 16 || 26
-</div>
+|}
-<nowiki>=SUMX2PY2(R1C1:R7C1,R1C2: R7C2)</nowiki>
+#SUMX2PY2(A1:C1,A2:C2)=8392.736500000003
-Consider an another example
+==See Also==
-<div align="left">[[Image:calci1.gif]]</div></div>
+==References==

Manuals/calci/SUMX2PY2 - Revision history

Swapna at 20:11, 26 June 2015

Devika: /* References */

Devika: /* References */

Abin at 11:38, 30 January 2014

Devika at 05:07, 27 January 2014

Devika at 05:05, 27 January 2014

MassBot1: Created page with " '''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ..."

MassBot1: Created page with "
'''SUMX2PY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ..."