writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 7:
Line 7: − + Line 21:
Line 21: − + Line 42:
Line 42: − +
no edit summary
*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.
|+Spreadsheet
|+Spreadsheet
|-
|-
! !! A !! B !! C !! D!! E !!F
! !! A !! B !! C !! D!! E
|-
|-
! 1
! 1
==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 ]]