Jak używać funkcji SUMXMY2 w Excelu

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:

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.

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