SUMX2PY2

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_y and added together.

  • array_y - The array or range of values whose squares will be added to 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.

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:

 

image2016-7-14 15:30:7.png   

image2016-7-14 15:30:52.png

 

There were errors rendering macro:

  • An unknown error occurred.