SUMX2MY2(array_x,array_y) returns the sum of the sum of squares of corresponding values in two arrays : SUMXMY2 « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =SUMX2MY2(A2:A8,B2:B8)
Input the formula: =SUMX2MY2(A2:A8,B2:B8)
20.56.SUMXMY2
20.56.1.SUMXMY2(array_x,array_y) returns the sum of the difference of squares of corresponding values in two arraysSUMXMY2(array_x,array_y) returns the sum of the difference of squares of corresponding values in two arrays
20.56.2.=SUMXMY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})=SUMXMY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})
20.56.3.SUMX2MY2(array_x,array_y) returns the sum of the sum of squares of corresponding values in two arraysSUMX2MY2(array_x,array_y) returns the sum of the sum of squares of corresponding values in two arrays
20.56.4.=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})=SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})