In data analysis, we may need to calculate the sum of square differences of corresponding values in two arrays.
Function syntaxSUMX2MY2 (array_x, array_y)
Array_x The first array or numerical range.
Array_y The second array or numeric range.
Function Description
This function accepts a number, array, name, or array reference as a parameter. If the parameter contains text, logical values, or blank cells, these values are ignored, but zero values are included in the calculation. If the number of elements in the two arrays is inconsistent, the function will return the error value #N/A.
The calculation formula of the sum of squared differences is as follows:
In mathematical operations, we often encounter the situation of finding the sum of the square differences of corresponding values in two arrays.
Using the SUMX2MY2 function in the WPS table can help us calculate quickly.
Next, we use an example to demonstrate the specific steps of using this function.
1. Select cell D2, click Insert function, enter and select the SUMX2MY2 function in the search box, and click OK;
2. In the pop-up dialog box, enter the parameters of the two arrays. Can be a number, array, name, or array reference. Note that text, logical values will be ignored, but zero values
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/tan-suo-shu-xue-san-jiao-han-shu-zhong-de-SUMX2MY2-ji-qi-ying-yong.html
评论列表(196条)
测试