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