SUMXMY2
Definition
Calculates the sum of the squares of differences of values in two arrays.
Sample Usage
Syntax
SUMXMY2(array_x, array_y)
array_x
- The array or range of values that will be reduced by corresponding entries inarray_y
, squared, and added together.array_y
- The array or range of values that will be subtracted from corresponding entries inarray_x
, the result squared, and all such results added together.
See Also
SUMX2PY2
: Calculates the sum of the sums of the squares 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 SUMXMY2 formula, start with your edited Excellentable: