Manuals/calci/SUMX2MY2 - Revision history

Swapna at 20:10, 26 June 2015

2015-06-26T20:10:52Z

Devika: /* References */

2015-05-14T19:12:54Z

References

Devika: /* References */

2015-05-14T19:09:00Z

References

Devika: /* Examples */

2015-02-12T09:09:11Z

Examples

Devika: /* Examples */

2015-02-12T08:59:53Z

Examples

Abin at 11:04, 30 January 2014

2014-01-30T11:04:25Z

Devika at 05:36, 27 January 2014

2014-01-27T05:36:18Z

Devika: /* Description */

2014-01-27T04:46:07Z

Description

Devika at 04:45, 27 January 2014

2014-01-27T04:45:19Z

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

2013-10-25T02:45:31Z

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

New page

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

'''SUMX2MY2'''(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 difference of square of corresponding values in two arrays.

'''Formula''' :-

SUMX2MY2 = Σ (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, SUMX2MY2 returns the #ERROR.

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

SUMX2MY2

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

Lets see an example in (Column3, Row1)

<nowiki>=SUMX2MY2(R1C1:R7C1,R1C2: R7C2)</nowiki>

SUMX2MY2 returns 313.

Consider an another example

<nowiki>=SUMX2MY2(R1C1:R7C1,R1C2: R6C2)</nowiki>

SUMX2MY2 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" | 313
|
|- 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>
----

← Older revision		Revision as of 20:10, 26 June 2015
Line 42:		Line 42:

	=SUMX2MY2(A1:E1,A2:E2) = -762.0000000000003		=SUMX2MY2(A1:E1,A2:E2) = -762.0000000000003
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|rwsX1KVhEnU\|280\|center\|SUMPRODUCT}}

	==See Also==		==See Also==

← Older revision		Revision as of 19:12, 14 May 2015
Line 49:		Line 49:

	==References==		==References==
−	*[http://www.techonthenet.com/excel/formulas/~~sumx2py2~~.php Sum of Difference of Squares]	+	*[http://www.techonthenet.com/excel/formulas/sumx2my2.php Sum of Difference of Squares]

← Older revision		Revision as of 19:09, 14 May 2015
Line 49:		Line 49:

	==References==		==References==
		+	*[http://www.techonthenet.com/excel/formulas/sumx2py2.php Sum of Difference of Squares]

← Older revision		Revision as of 09:09, 12 February 2015
Line 27:		Line 27:

	=SUMX2MY2(A1:D1,A2:D2) = 3222		=SUMX2MY2(A1:D1,A2:D2) = 3222
		+
		+
		+	{\| class="wikitable"
		+	\|+Spreadsheet
		+	\|-
		+	! !! A !! B !! C !! D !! E
		+	\|-
		+	! 1
		+	\| 45 \|\| -12 \|\| 14 \|\| -7 \|\| 23.3
		+	\|-
		+	! 2
		+	\| -18 \|\| 41.7 \|\| -20 \|\| 34 \|\| 10
		+	\|}
		+
		+	=SUMX2MY2(A1:E1,A2:E2) = -762.0000000000003

	==See Also==		==See Also==

@@ Line 26: / Line 26: @@
 |}
-=SUMX2MY2(A1:D1,A2:D2) = null
+=SUMX2MY2(A1:D1,A2:D2) = 3222
 ==See Also==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''SUMX2MY2(x,y)'''</div><br/>
 *<math> x </math> and <math> y </math>  are the array of values.
 ==Description==
 *This function gives the sum of the difference of squares of corresponding values in <math> x </math> and  <math> y </math>.
-*In <math> SUMX2MY2(x,y), x </math> is the first array of real values and <math> y </math> is the second array of real values.
+*In <math> SUMX2MY2(x,y)</math>, <math>x</math> is the first array of real values and <math> y </math> is the second array of real values.
 *This  function is defined by:  <math> SUMX2MY2= \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
-. Any one of the argument is nonnumeric or not a real number.
+. Any one of the argument is non-numeric 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==
-x={29,71,10,16}
+{| class="wikitable"
-y={16,50,8,14}
+|+Spreadsheet
-SUMX2MY2(B1:B4,C1:C4) = null
+|-
 ==See Also==
@@ Line 24: / Line 32: @@
 *[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
 *[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
 ==References==

Manuals/calci/SUMX2MY2 - Revision history

Swapna at 20:10, 26 June 2015

Devika: /* References */

Devika: /* References */

Devika: /* Examples */

Devika: /* Examples */

Abin at 11:04, 30 January 2014

Devika at 05:36, 27 January 2014

Devika: /* Description */

Devika at 04:45, 27 January 2014

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

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