SUMX2PY2
Returns the sum of the sum of squares of corresponding values in two arrays: Σ(x² + y²). Used in regression analysis.
SUMX2PY2(array_x, array_y)Arguments
array_xThe first array or range of values.array_yThe second array or range of values (must match array_x).
=SUMX2PY2({2,3,4},{1,2,3})(4+1) + (9+4) + (16+9) = 43
=SUMX2PY2(A1:A3,B1:B3)Σ(Aᵢ² + Bᵢ²)
- •Returns #N/A if the two arrays have different sizes
- •Empty cells, logical values and text are ignored
- •Compare with SUMX2MY2 (sum of differences) and SUMXMY2 (sum of squared differences)
- •Mismatching the size of array_x and array_y, which returns a #N/A error since every value in one array needs a corresponding value in the other
- •Confusing SUMX2PY2 with SUMSQ - SUMX2PY2 works across two paired arrays, adding the squares of both x and y for each pair, while SUMSQ simply sums the squares of values within a single set
- •Expecting the result to ever be negative - since every term is a sum of two squares, SUMX2PY2's total is always zero or positive
SUMX2MY2Calculates the sum of x²−y² instead of x²+y², the subtraction counterpart to SUMX2PY2's addition.SUMXMY2Calculates the sum of (x−y)² for each pair, a fundamentally different calculation from SUMX2PY2's sum of x²+y².SUMSQCalculates the sum of squares within a single set of values, rather than SUMX2PY2's comparison between two paired sets.Why does SUMX2PY2 return a #N/A error?
array_x and array_y probably don't have the same number of values - each element in one array needs a corresponding element in the other at the same position.
Can SUMX2PY2 ever return a negative result?
No, since every term being summed is the sum of two squares (x²+y²), and squares are always non-negative, the total is always zero or positive.
How is SUMX2PY2 different from SUMSQ?
SUMX2PY2 works across two paired arrays, summing x² plus y² for each corresponding pair. SUMSQ works on a single set of values, simply summing the squares of each one.
Need to translate a formula using SUMX2PY2?
Use our translator to convert your complete formula