SUMX2PY2(range_x, range_y)

The SUMX2PY2 function calculates the sum of the sum of squares of corresponding values in two arrays, according to the formula:

image\ebx_1968225903.gif

The number of values in both arrays must be the same

For example:

SUMX2PY2({4,5,6}, {7,4,3})

returns 151, that is (4^2 + 7^2) + (5^2 + 4^2) + (6^2 + 3^2).

See also:

Other mathematical functions