Formula Functions > Functions R to S > SUMXMY2 |
This function returns the sum of the square of the differences of corresponding values in two arrays.
SUMXMY2(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.
SUMXMY2(A1:A17,B1:B17)
This function is available in product version 1.0 or later.
SUMX2PY2 | SUMX2MY2 | SUM | Math and Trigonometry Functions