Skip to main content

SUMX2MY2

Definition

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:

   

 

 

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

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

If this problem persists, please contact our support.