SUMX2MY2 Function Explained
The SUMX2MY2 Function in Microsoft Excel calculates the sum of the differences of squares of corresponding values in two arrays. It takes two arrays of the same size as arguments and returns the sum of the squares of the differences between the corresponding values in the two arrays.
SUMX2MY2 Function Syntax
SUMX2MY2(array_x, array_y)
- array_x: The first array of numbers to be added and then squared.
- array_y: The second array of numbers to be subtracted and then squared.