How to Use Excel's SUMX2PY2 Function

Excel's SUMX2PY2 function returns the sum of the squares of two sets of values and is named after the mnemonic "SUM of X^2 Plus Y^2." This term is encountered frequently in statistical calculations and the following steps will show how it is used.

Instructions

Difficulty: Moderate

1. Learn the syntax for SUMX2PY2. It is SUMX2PY2(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 SUMX2PY2. Cells in an array that contain logical values, text or are empty will be ignored but cells containing a zero value will be included. SUMX2PY2 returns the #N/A error value when x_array and y_array contain a different number of values.
3. Calculate the return value of SUMX2PY2. It will be the sum of (x^2 + y^2) for each x,y value given in the argument list.
4. Enter the following into the first two columns of an Excel spreadsheet for a simple example of SUMX2PY2:
   
   Row 1: x_array and y_array;
   Row 2: 2 and 5;
   Row 3: 3 and 4.
   
   =SUMX2PY2(A1:A2,B1:B2) is evaluated as (2^2 + 5^2) + (3^2 + 4^2) = (4+25) + (9+16) = 29 + 25 = 54. Note how the x_array is in the first column and the y_array is in the second column. Observe also that these values may be evaluated in any order (because SUMX2PY2 uses addition) unlike SUMX2MY2, which involves subtraction.
5. Look at the following example of SUMX2PY2 using inline arguments:
   
   =SUMX2PY2({1, 4, 2, 1, 6, 8, 5}, {3, 8, 12, 8, 3, 2, 4}) will return 457. 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.