ZCubes Wiki

Difference between revisions of "Manuals/calci/SUMX2MY2"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMX2MY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ...")
 
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''SUMX2MY2(x,y)'''</div><br/>
 +
*<math> x </math> and <math> y </math>  are the array of values.
  
−
'''SUMX2MY2'''(ArrayX, ArrayY)
+
==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)</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
 +
        1. Any one of the argument is non-numeric 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==
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D
 +
|-
 +
! 1
 +
| 29 || 71 || 10 ||16
 +
|-
 +
! 2
 +
| 16 || 50 || 8 || 14
 +
|}
  
−
'''ArrayX''' - represents the first array of values.
+
=SUMX2MY2(A1:D1,A2:D2) = 3222
  
−
'''ArrayY''' - represents the second array of values.
 
  
−
</div>
+
{| class="wikitable"
−
----
+
|+Spreadsheet
−
<div id="1SpaceContent" class="zcontent" align="left">
+
|-
−
 
+
! !! A !! B !! C !! D !! E
−
It returns the sum of the difference of square of corresponding values in two arrays.
+
|-
−
 
+
! 1
−
'''Formula''' :-
+
| 45 || -12 || 14 || -7 || 23.3
−
 
+
|-
−
SUMX2MY2 = Σ (x<sup>2</sup> - y<sup>2</sup>)
+
! 2
−
 
+
| -18 || 41.7 || -20 || 34 || 10
−
</div>
+
|}
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
−
 
 
−
If ArrayX and ArrayY have different number of values, SUMX2MY2 returns the #ERROR.
 
  
−
</div>
+
=SUMX2MY2(A1:E1,A2:E2) = -762.0000000000003
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
SUMX2MY2
+
==Related Videos==
  
−
</div></div>
+
{{#ev:youtube|rwsX1KVhEnU|280|center|SUMPRODUCT}}
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column3, Row1)
+
==See Also==
−
 
+
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2]]
−
<nowiki>=SUMX2MY2(R1C1:R7C1,R1C2: R7C2)</nowiki>
+
*[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
−
 
+
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]]
−
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>
+
==References==
−
----
+
*[http://www.techonthenet.com/excel/formulas/sumx2my2.php Sum of Difference of Squares]

Latest revision as of 14:10, 26 June 2015

SUMX2MY2(x,y)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } are the array of values.

Description

  • This function gives the sum of the difference of squares of corresponding values in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } .
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUMX2MY2(x,y)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the first array of real values and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } is the second array of real values.
  • This function is defined by: Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUMX2MY2= \sum (x^2-y^2) } .
  • 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 non-numeric or not a real number.
       2. The arguments containing the error values or text that cannot be translated in to numbers.
       3. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x}
 and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y}
 are having different number of values.

Examples

Spreadsheet
A B C D
1 29 71 10 16
2 16 50 8 14

=SUMX2MY2(A1:D1,A2:D2) = 3222


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

Related Videos

SUMPRODUCT

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SUMX2MY2&oldid=202067"