This function returns the sum of the difference of the squares of corresponding values in two arrays.
SUMX2MY2(array_x,array_y)
This function has these arguments:
Argument | Description |
---|---|
array_x | First array of values (x’s) |
array_y | Second array of values (y’s) |
The arrays must be the same size.
Accepts numeric data for all arguments. Returns numeric data.
SUMX2MY2(A1:A17,B1:B17)