Difference between revisions of "Manuals/calci/SUMX2MY2"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SUMX2MY2'''(ArrayX, ArrayY) where, '''ArrayX''' - represents the first array of values. '''ArrayY''' - ...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <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. | ||
| + | *This function is defined by <math> 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 nonnumeric or not a real number. | ||
| + | 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. | ||
| − | |||
| − | + | ==Examples== | |
| + | x={29,71,10,16} | ||
| + | y={16,50,8,14} | ||
| + | SUMX2MY2(B1:B4,C1:C4) = null | ||
| − | |||
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/SUMX2PY2 | SUMX2PY2]] | ||
| + | *[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | ||
| + | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | ||
| − | |||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 22:45, 26 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 <math> 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
is the first array of real values and 1. Any one of the argument is nonnumeric or not a real number.
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.
Examples
x={29,71,10,16} y={16,50,8,14} SUMX2MY2(B1:B4,C1:C4) = null
See Also