SUMX2PY2()
Syntax. SUMX2PY2(array_x,array_y)
Definition. This function returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations (see Figure 16-36).
Arguments
array_x (required) The first array or range of values
array_y (required) The second array or range of values
Background. The arguments should be numbers, names, arrays, or references containing numbers.
If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.
If array_x and array_y have a different number of values, the SUMX2PY2() function returns the #N/A
error.
The equation for the sum of the difference ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.