SUM_XMY2

Syntax:

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

This 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).

Formula:

SUM_XMY2 = i=n (xiyi)2

where n is the number of values and xi and yi are the i-th pair of values.

Revisions:

This function was added in 2.00.