Functions
SUMXMY2
Returns sum of squares of differences
Try it
When to use it
When should I use SUMXMY2?
Use SUMXMY2 to measure the total squared difference between two parallel arrays — useful in regression analysis and error metrics where you want the sum of (x − y)² for each pair.
Used in
Syntax
SUMXMY2(array_x, array_y)Examples
=SUMXMY2({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => 79
=SUMXMY2({1,2,3},{4,5,6}) // => 27
=SUMXMY2({1,2,3},{1,2,3}) // => 0