Difference between revisions of "Manuals/calci/SUMXMY2"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMXMY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - r...") |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SUMXMY2(x,y)'''</div><br/> |
| + | *<math> x </math> and <math> y </math> are the array of values. | ||
| − | + | ==Description== | |
| + | *This function gives the sum of squares of differences of corresponding values in <math> x </math> and <math> y </math>. | ||
| + | *In <math> SUMXMY2(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> SUMXMY2= \sum (x-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. | ||
| − | + | ==Examples== | |
| − | + | {| class="wikitable" | |
| − | + | |+Spreadsheet | |
| − | + | |- | |
| − | + | ! !! A !! B !! C !! D!! E | |
| − | + | |- | |
| − | + | ! 1 | |
| − | + | | 80.16 || 78.42 || 65.21 || 12 || 10 | |
| − | + | |- | |
| − | + | ! 2 | |
| − | + | | 65.9 || 59.80 || 45.12 || 15 ||17 | |
| − | + | |- | |
| − | + | ! 3 | |
| − | + | | 0 || 9 || 18 || 27 || 36 | |
| − | + | |- | |
| − | + | !4 | |
| − | + | | 8 || 18 || 29 || 37 || 45 | |
| − | + | |} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | #=SUMXMY2(A1:C1, A2:C2) = 953.660099999 | |
| + | #=SUMXMY2(A3:E3,A4:E4) = 447 | ||
| + | #=SUMXMY2([10,13,17,19,23],[7,9,19,31,37]) = 369 | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|rwsX1KVhEnU|280|center|SUMPRODUCT}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/SUMX2PY2 | SUMX2PY2]] | |
| − | + | *[[Manuals/calci/SUMX2MY2 | SUMX2MY2 ]] | |
| − | | | + | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==References== | |
| − | + | *[http://www.techonthenet.com/excel/formulas/sumxmy2.php Sum of the Squares of the differences] | |
Latest revision as of 13:49, 27 January 2017
SUMXMY2(x,y)
- and are the array of values.
and 
are the array of values.Description
- This function gives the sum of squares of differences 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 non-numeric or not a real number.
2. The arguments containing the error values or text that cannot be translated in to numbers.
3. 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
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 80.16 | 78.42 | 65.21 | 12 | 10 |
| 2 | 65.9 | 59.80 | 45.12 | 15 | 17 |
| 3 | 0 | 9 | 18 | 27 | 36 |
| 4 | 8 | 18 | 29 | 37 | 45 |
- =SUMXMY2(A1:C1, A2:C2) = 953.660099999
- =SUMXMY2(A3:E3,A4:E4) = 447
- =SUMXMY2([10,13,17,19,23],[7,9,19,31,37]) = 369