How to Use Excel's SUMX2MY2 Function

Excel's SUMX2MY2 function calculates the sum of the differences of the squares of two sets of values and is named after the mnemonic "SUM of X^2 Minus Y^2." This function is frequently used in statistical applications and the following steps will show how it is used.

Instructions

Difficulty: Moderate

1. Learn the syntax for SUMX2MY2. It is SUMX2MY2(x_array,y_array) where x_array is an array for the x values and y_array is an array for the y values.
2. Use arrays, names and numbers for the arguments to SUMX2MY2. Cells in an array that contain logical values, text or are empty will be ignored, but cells containing the zero value will be included. SUMX2MY2 will return the #N/A error value if x_array and y_array do not have the same number of values.
3. Calculate the return value of SUMX2MY2. It will be the sum of (x^2 – y^2) for each (x,y) pair in the argument list.
4. Enter the following into the first two columns of an Excel spreadsheet for a simple example of SUMX2MY2:
   
   Row 1: x_array and y_array;
   Row 2: 2 and 3;
   Row 3: 5 and 7.
   
   =SUMX2MY2(A1:A2,B1:B2) is evaluated as (2^2 – 3^2) + (5^2 – 7^2) = (4-9) + (25-49) = -5 + -24 = -29. Note how the x_array is in the first column and the y_array is in the second column.
5. Look at the following example of SUMX2MY2 using inline arguments:
   
   =SUMX2MY2({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4}) will return -55. Note the use of curly braces to define the two arrays.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.