SUMX2PY2 « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial






20.55.SUMX2PY2
20.55.1.SUMX2PY2(array_x,array_y) returns the sum of squares of differences of corresponding values in two arraysSUMX2PY2(array_x,array_y) returns the sum of squares of differences of corresponding values in two arrays
20.55.2.=SUMX2PY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})=SUMX2PY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4})