Manuals/calci/SUMXMY2

From ZCubes Wiki
Jump to navigation Jump to search
SUMXMY2(x,y)


  • and are the array of values.

Description

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

Spreadsheet
A B C D E
1 80.16 78.42 65.21 12 10
2 65.9 59.80 45.12 15 17
3 0 9 18 27 36
4 8 18 29 37 45
  1. =SUMXMY2(A1:C1, A2:C2) = 953.660099999
  2. =SUMXMY2(A3:E3,A4:E4) = 447
  3. =SUMXMY2([10,13,17,19,23],[7,9,19,31,37]) = 369

Related Videos

SUMPRODUCT

See Also

References