Jak używać funkcji SUMXMY2 w Excelu

Polskie Angielski
SUMA.XMY.2 SUMXMY2

The SUMXMY2 function in Microsoft Excel and Google Sheets is used to calculate the sum of the squares of differences between corresponding values in two data ranges. This function is particularly useful in statistical data analysis and processing, especially when it is necessary to assess the differences between two sets of numbers.

Function Syntax Description

 SUMXMY2(data1, data2) 

where data1 and data2 are two data ranges that must have the same dimension.

Example of usage:

 SUMXMY2(A1:A5, B1:B5) 

This example calculates the sum of the squares of differences between the values in cells from A1 to A5 and the corresponding values in cells from B1 to B5.

Tasks where the function can be applied

  • Evaluating the statistical difference between two samples.
  • Calculating metrics for optimization in machine learning (e.g., the least squares method).

Practical Task 1: Comparing Test Results

Imagine we have the test results of two groups of students in mathematics. We need to assess how significantly the results of these groups differ. The data are placed in two columns in Excel:

Group A Group B
76 82
88 90
94 92
85 88
80 84

We will use SUMXMY2 for the evaluation:

 =SUMXMY2(A1:A5, B1:B5) 

The result will equal the sum of the squares of differences between the scores of each student in Group A and the corresponding student in Group B. This resultant number gives us an insight into the differences in outcomes between the two groups.

Practical Task 2: Assessing the Accuracy of Forecast Models

Suppose we have developed a sales forecasting model and want to check its accuracy. Real sales data is represented in one column, and the forecasts in another.

Real Sales Forecast
150 155
130 125
200 195
180 185
160 162

Let”s use the function to assess the model”s accuracy:

 =SUMXMY2(A1:A5, B1:B5) 

A lower result value indicates that the forecasts are close to the actual data, whereas a high value suggests significant discrepancies between the forecast and reality.

Więcej informacji: https://support.microsoft.com/pl-pl/office/funkcja-suma-xmy-2-9d144ac1-4d79-43de-b524-e2ecee23b299

Inne funkcje
Dodaje argumenty
Dodaje komórki w zakresie, które spełniają wiele kryteriów
Zwraca sumę iloczynów odpowiednich elementów tablicy
Dodaje komórki określone przez podane kryterium
Zwraca sumę kwadratów argumentów
Zwraca sumę częściową listy lub bazy danych