SUMX2MY2

Calculates the sum of the differences of the squares of values in two arrays.

Sample Usage

Syntax

SUMX2MY2(array_x, array_y)

• array_x - The array or range of values whose squares will be reduced by the squares of corresponding entries inarray_y and added together.

• array_y - The array or range of values whose squares will be subtracted from the squares of corresponding entries inarray_x and added together.

See Also

SUMXMY2: Calculates the sum of the squares of differences of values in two arrays.

SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.

In order to use the SUMX2MY2 formula, start with your edited Excellentable:

	A	B
1	array_X	array_Y
2	9	8
3	6	2
4	1	-2
5
6	SUMX2MY2	46