Overview of the SUMX2MY2 (TOPX2EY2) Function

The SUMX2MY2 function, or TOPX2EY2 in Turkish, takes two arrays or ranges and calculates the sum of the differences between the squares of corresponding elements from each array. Both arrays must be of equal length.

Syntax and Parameters

The syntax for MS Excel and Google Sheets is:

=SUMX2MY2(array1, array2)

• array1: The first array, where the square of each element is subtracted by the square of the corresponding element in the second array and then summed.
• array2: The second array, in which the squares of its elements are subtracted from the squares of the corresponding elements of the first array.

Example Usage

Let”s look at a simple example to see how the function is used:

=SUMX2MY2({1,2,3}, {4,5,6})

In this example, the squares of the elements of the first array are {1, 4, 9} and of the second array are {16, 25, 36}. The function sums up {1-16, 4-25, 9-36} = {-15, -21, -27}, resulting in -63.

Practical Scenarios

Scenario 1: Physics Experiment

In a physics experiment, we may want to calculate the sum of the squared differences of speed readings from two different sensors. This can be used to understand differences in energy.

=SUMX2MY2({2, 3, 4}, {1, 1, 2})

The readings from the first sensor are {2, 3, 4} and from the second sensor are {1, 1, 2}. When we calculate the squares of both arrays, we get {4, 9, 16} and {1, 1, 4}, respectively. The sum of these differences {3, 8, 12} results in 23.

Scenario 2: Accounting Application

A company might want to analyze the squared differences of sales figures for the same period across two different years. This can help understand the magnitude of sales increase or decrease.

=SUMX2MY2({120, 150, 180}, {100, 140, 160})

Here, the squared differences between the sales of the first year and the second year are {1600, 100, 400}, totaling 2100. This represents the intensity of the change in sales.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/topx2ey2-işlevi-9e599cc5-5399-48e9-a5e0-e37812dfa3e9