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 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