SUMXMY2(range_x, range_y)

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

image\ebx_1062480293.gif

The number of values in both arrays must be the same

For example:

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

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

See also:

Other mathematical functions