SUM_XMY2

Syntax:

SUM_XMY2(x-data:array, y-data:array)

The SUM_XMY2 function returns the sum of the squares of the difference of corresponding values from the x-data array (or range of cells) and the y-data array (or range of cells).

The equation used is:

Σi=n (xi - yi)2

where xi and yi are each pair of values and n is the number of values.

Added in 2.00.