Difference between revisions of "Manuals/calci/SUMX2PY2"

From ZCubes Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
*In <math> SUMX2PY2(x,y) ,x </math> is the first array of real values and <math> y </math> is the second array of real values.
 
*In <math> SUMX2PY2(x,y) ,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.
 
*It is  mostly common term in statistical calculations.
*This  function is defined by  <math> SUMX2PY2= \sum (x^2+y^2) </math>.  
+
*This  function is defined by : <math> SUMX2PY2= \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.  
Line 21: Line 21:
 
|+Spreadsheet
 
|+Spreadsheet
 
|-
 
|-
! !! A !! B !! C !! D!! E !!F
+
! !! A !! B !! C !! D!! E  
 
|-
 
|-
 
! 1
 
! 1
Line 42: Line 42:
  
 
==See Also==
 
==See Also==
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2]]
+
*[[Manuals/calci/SUMX2MY2 | SUMX2MY2]]
 
*[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
 
*[[Manuals/calci/SUMXMY2  | SUMXMY2 ]]
 
*[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
 
*[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]

Revision as of 00:07, 27 January 2014

SUMX2PY2(x,y)


  • and are the array of values.


Description

  • This function gives the sum of the sum of squares 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 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

Spreadsheet
A B C D E
1 25.5 34.2 67.9 12 10
2 12.56 40.45 12.98 15 17
3 0 5 7 9 18
4 12 22 31 16 26
  1. SUMX2PY2(A1:C1,A2:C2)=8392.736500000003
  2. SUMX2PY2(A3:E3,A4:E4)=3000
  3. SUMX2PY2([10,20,30],[5,15,25])=2275


See Also


References