This function returns the sum of the sum of squares of corresponding values in two arrays.
Syntax
SUMX2PY2(array_x,array_y)
Arguments
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.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
SUMX2PY2(A1:A17,B1:B17)
See Also