- Picture and text skills
- Case
Calculate the sum of the squared differences of the corresponding values in the two arrays.
Grammar
SUMX2MY2 (array_x, array_y)
Array_x The first array or numerical area.
Array_y The second array or numerical area.
Description
Parameters can be values, arrays, names, or array references.
If the array or reference parameter contains text, logical values, and blank cells, these values will be ignored; however, cells containing zero values will be counted.
If array_x and array_y have different numbers of elements, SUMX2MY2 will return the error value #N/A.
The calculation formula of the sum of squared differences is as follows:
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/shu-xue-he-san-jiao-han-shu-SUMX2MY2-han-shu-liang-shu-zu-dui-ying-zhi-ping-fang-cha-zhi-he.html
评论列表(196条)
测试