Functions
SUMX2MY2
Returns sum of (x^2 - y^2)
Try it
When to use it
When should I use SUMX2MY2?
Use SUMX2MY2 to compute the sum of differences of squares (x squared minus y squared) across two arrays, useful in statistical comparisons and difference-of-squares calculations.
Used in
Syntax
SUMX2MY2(array_x, array_y)Examples
=SUMX2MY2({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => -55
=SUMX2MY2({1,2,3},{4,5,6}) // => -63
=SUMX2MY2({1,2,3},{1,2,3}) // => 0