SUMX2MY2(range_x, range_y)

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

image\ebx_-951103237.gif

The number of values in both arrays must be the same

For example:

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

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

See also:

Other mathematical functions