Skip to main content

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 in array_y, squared, and added together.

  • array_y - The array or range of values that will be subtracted from corresponding entries in array_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:

   

 

A
B
1
array_X
array_Y
2
9
8
3
6
2
4
1
-2
5
6
SUMXMY2
26

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.