Difference between revisions of "Manuals/calci/SUMX2MY2"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''SUMX2MY2(x,y)'''</div><br/> | <div style="font-size:30px">'''SUMX2MY2(x,y)'''</div><br/> | ||
*<math> x </math> and <math> y </math> are the array of values. | *<math> x </math> and <math> y </math> are the array of values. | ||
| − | |||
==Description== | ==Description== | ||
*This function gives the sum of the difference of squares of corresponding values in <math> x </math> and <math> y </math>. | *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>. | *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. | *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. | *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 | *This function will give the result as error when | ||
| − | 1. Any one of the argument is | + | 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. | 2. The arguments containing the error values or text that cannot be translated in to numbers. | ||
| − | 3. x and y are having different number of values. | + | 3. <math>x</math> and <math>y</math> are having different number of values. |
==Examples== | ==Examples== | ||
| − | + | {| class="wikitable" | |
| − | + | |+Spreadsheet | |
| − | + | |- | |
| + | ! !! A !! B !! C !! D | ||
| + | |- | ||
| + | ! 1 | ||
| + | | 29 || 71 || 10 ||16 | ||
| + | |- | ||
| + | ! 2 | ||
| + | | 16 || 50 || 8 || 14 | ||
| + | |} | ||
| + | =SUMX2MY2(A1:D1,A2:D2) = null | ||
==See Also== | ==See Also== | ||
| Line 24: | Line 32: | ||
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | *[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | ||
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | ||
| − | |||
==References== | ==References== | ||
Revision as of 05:04, 30 January 2014
SUMX2MY2(x,y)
- and are the array of values.
and 
are the array of values.Description
- This function gives the sum of the difference of squares of corresponding values in and .
- In , is the first array of real values and is the second array of real values.
- 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 | |
|---|---|---|---|---|
| 1 | 29 | 71 | 10 | 16 |
| 2 | 16 | 50 | 8 | 14 |
=SUMX2MY2(A1:D1,A2:D2) = null