writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − − + − + + Line 13:
Line 13: − + − Line 36:
Line 35: − + − + − + − Line 45:
Line 43: −
no edit summary
<div style="font-size:30px">'''SUMX2PY2(x,y)'''</div><br/>
<div style="font-size:30px">'''SUMX2PY2(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 sum of squares of corresponding values in <math> x </math> and <math> y </math>.
*This function gives the sum of the sum of squares of corresponding values in <math> x </math> and <math> y </math>.
*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)</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.
*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.
1. Any one of the argument is nonnumeric or not a real number.
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.
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==
|}
|}
#SUMX2PY2(A1:C1,A2:C2)=8392.736500000003
#=SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
#SUMX2PY2(A3:E3,A4:E4)=3000
#=SUMX2PY2(A3:E3,A4:E4) = 3000
#SUMX2PY2([10,20,30],[5,15,25])=2275
#=SUMX2PY2([10,20,30],[5,15,25]) = 2275
==See Also==
==See Also==
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]]
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]]
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]]
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]]
==References==
==References==