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:

   

 

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.