Definition
Calculates the sum of the sums of the squares of values in two arrays.
Sample Usage
Syntax
SUMX2PY2(array_x, array_y)
-
array_x- The array or range of values whose squares will be added to the squares of corresponding entries inarray_yand added together. -
array_y- The array or range of values whose squares will be added to the squares of corresponding entries inarray_xand added together.
See Also
SUMXMY2: Calculates the sum of the squares of differences of values in two arrays.
SUMX2MY2: Calculates the sum of the differences of the squares of values in two arrays.
In order to use the SUMX2PY2 formula, start with your edited Excellentable:
There were errors rendering macro:
- An unknown error occurred.