求2组数据的相似性算法.
+--------+--------+
| size1 | size2 |
+--------+--------+
| NULL | 52.10 |
| NULL | 56.14 |
| NULL | 56.97 |
| 57.34 | 57.34 |
| NULL | 58.22 |
| NULL | 64.09 |
| NULL | 66.80 |
| NULL | 68.46 |
| NULL | 69.39 |
| 72.34 | 72.34 |
| 76.10 | 76.10 |
| NULL | 79.52 |
| NULL | 84.25 |
| 88.79 | 88.79 |
| 93.56 | 93.56 |
| 94.74 | 94.74 |
| 100.06 | 100.06 |
| 101.03 | 101.03 |
| 103.33 | 103.33 |
| 106.67 | 106.67 |
| 109.91 | 109.91 |
| 119.39 | 119.39 |
| 126.29 | 126.29 |
| 128.87 | 128.87 |
| NULL | 132.92 |
| 144.99 | 144.99 |
| NULL | 150.77 |
| NULL | 151.99 |
| 156.75 | 156.75 |
| 159.96 | 159.96 |
| NULL | 164.63 |
| 165.49 | 165.49 |
| 188.59 | 188.59 |
| 211.50 | 211.50 |
| 214.28 | 214.28 |
| NULL | 221.30 |
| 223.06 | 223.06 |
| 231.31 | 231.31 |
| NULL | 241.52 |
| 262.73 | 262.73 |
| 276.60 | 276.60 |
| NULL | 285.23 |
| 291.71 | 291.71 |
| 316.93 | 316.93 |
| 324.32 | 324.32 |
| NULL | 345.69 |
| NULL | 472.20 |
| 485.66 | 485.66 |
| 501.58 | 501.58 |
| NULL | 546.34 |
+--------+--------+
50 rows in set (0.00 sec)
+--------+--------+
| size1 | size2 |
+--------+--------+
| NULL | 51.95 |
| NULL | 56.58 |
| 57.36 | 57.36 |
| 61.21 | 61.21 |
| NULL | 62.38 |
| 65.44 | 65.44 |
| NULL | 66.78 |
| 67.47 | 67.47 |
| NULL | 68.47 |
| NULL | 69.23 |
| NULL | 70.26 |
| NULL | 72.31 |
| NULL | 73.53 |
| NULL | 74.27 |
| 76.24 | 76.24 |
| 78.28 | 78.28 |
| NULL | 79.41 |
| 83.36 | 83.36 |
| NULL | 84.31 |
| NULL | 85.59 |
| NULL | 86.26 |
| NULL | 87.85 |
| 88.85 | 88.85 |
| NULL | 92.51 |
| 93.64 | 93.64 |
| 94.82 | 94.82 |
| 100.13 | 100.13 |
| 101.11 | 101.11 |
| 103.42 | 103.42 |
| NULL | 104.66 |
| NULL | 105.83 |
| 106.75 | 106.75 |
| 109.72 | 109.72 |
| NULL | 112.82 |
| 115.39 | 115.39 |
| 119.44 | 119.44 |
| 121.39 | 121.39 |
| 122.81 | 122.81 |
| 126.52 | 126.52 |
| 128.96 | 128.96 |
| NULL | 132.92 |
| 133.93 | 133.93 |
| NULL | 136.01 |
| 143.89 | 143.89 |
| 145.00 | 145.00 |
| NULL | 150.76 |
| NULL | 152.04 |
| NULL | 153.62 |
| 156.82 | 156.82 |
| 159.99 | 159.99 |
| 165.55 | 165.55 |
| NULL | 169.19 |
| NULL | 170.48 |
| 171.47 | 171.47 |
| NULL | 174.22 |
| NULL | 175.28 |
| NULL | 193.15 |
| NULL | 199.02 |
| NULL | 201.95 |
| 211.50 | 211.50 |
| 214.28 | 214.28 |
| 223.04 | 223.04 |
| 231.25 | 231.25 |
| NULL | 236.03 |
| 240.59 | 240.59 |
| 253.35 | 253.35 |
| 254.31 | 254.31 |
| 262.69 | 262.69 |
| NULL | 272.24 |
| 276.58 | 276.58 |
| NULL | 285.16 |
| 289.45 | 289.45 |
| 291.60 | 291.60 |
| NULL | 296.81 |
| NULL | 297.05 |
| 307.34 | 307.34 |
| 316.90 | 316.90 |
| 324.32 | 324.32 |
| NULL | 345.37 |
| NULL | 359.31 |
| 363.33 | 363.33 |
| NULL | 377.77 |
| 403.10 | 403.10 |
| NULL | 455.89 |
| NULL | 472.27 |
| 485.64 | 485.64 |
| 493.55 | 493.55 |
| 501.59 | 501.59 |
+--------+--------+
size1是待分析数据,size2是标准数据,如何计算size1对于size2的相似度.
多谢解答,在线等.