data analysis
工作表1
| Population (in million) | GDP per capita (in USD 1000) | Distance from China (in miles) | Corruption rating score | Actual import value from China (in USD million) | |
| India | 1339.18 | 6.6 | 1,854 | 40 | 582,280 |
| United States | 324.46 | 57.4 | 7,237 | 74 | 4,092,139 |
| Indonesia | 263.99 | 11.7 | 2,609 | 37 | 343,420 |
| Brazil | 209.29 | 15.2 | 10,335 | 40 | 274,122 |
| Pakistan | 197.02 | 5.1 | 2,041 | 32 | 164,419 |
| Russia | 143.99 | 26.5 | 1,774 | 29 | 347,569 |
| Mexico | 129.16 | 18.9 | 7,970 | 30 | 337,918 |
| Japan | 127.48 | 41.3 | 1,893 | 72 | 1,356,164 |
| Germany | 82.11 | 48.1 | 4,489 | 81 | 691,548 |
| Iran | 81.16 | 18.1 | 2,866 | 29 | 177,701 |
| Turkey | 80.75 | 24.9 | 3,697 | 41 | 186,078 |
| United Kingdom | 66.18 | 42.5 | 4,834 | 81 | 595,671 |
| France | 64.98 | 42.3 | 4,985 | 60 | 267,484 |
| Italy | 59.36 | 36.8 | 4,701 | 47 | 278,344 |
| South Africa | 56.72 | 13.2 | 6,982 | 45 | 158,579 |
| South Korea | 50.98 | 37.7 | 1,316 | 53 | 1,012,864 |
| Colombia | 49.07 | 14.1 | 9,641 | 37 | 37,634 |
| Spain | 46.35 | 36.4 | 5,461 | 58 | 218,524 |
| Sudan | 40.53 | 4.4 | 4,809 | 14 | 23,945 |
| Iraq | 38.27 | 17.9 | 3,393 | 17 | 79,092 |
| Poland | 38.17 | 27.8 | 4,126 | 62 | 143,449 |
| Canada | 36.62 | 46.4 | 5,832 | 82 | 294,226 |
| Morocco | 35.74 | 8.3 | 5,986 | 37 | 28,972 |
| Afghanistan | 35.53 | 1.9 | 3,107 | 15 | 3,618 |
| Peru | 32.17 | 12.9 | 10,593 | 35 | 63,550 |
| Venezuela | 31.98 | 13.8 | 9,445 | 17 | 53,158 |
| Uzbekistan | 31.91 | 6.6 | 2,153 | 21 | 22,288 |
| Malaysia | 31.62 | 26.7 | 2,192 | 49 | 439,804 |
| Angola | 29.78 | 6.8 | 6,467 | 18 | 37,172 |
| Nepal | 29.30 | 2.5 | 1,279 | 29 | 8,327 |
| Ghana | 28.83 | 4.4 | 6,733 | 43 | 53,089 |
| Yemen | 28.52 | 2.4 | 3,684 | 14 | 14,300 |
| North Korea | 25.49 | 1.7 | 1,301 | 12 | 29,429 |
| Australia | 24.45 | 48.9 | 4,644 | 79 | 403,065 |
| Cameroon | 24.05 | 3.2 | 6,023 | 26 | 18,333 |
| Niger | 21.48 | 1.1 | 5,842 | 35 | 17,335 |
| Sri Lanka | 20.88 | 12.3 | 2,434 | 36 | 43,041 |
| Romania | 19.68 | 22.3 | 4,024 | 48 | 31,622 |
| Burkina Faso | 19.19 | 1.8 | 6,578 | 42 | 155 |
| Malawi | 18.62 | 1.1 | 5,675 | 31 | 2,460 |
| Mali | 18.54 | 2.3 | 6,473 | 32 | 2,704 |
| Syria | 18.27 | 2.9 | 3,604 | 13 | 10,226 |
| Kazakhstan | 18.20 | 25.1 | 2,066 | 29 | 84,412 |
| Chile | 18.05 | 24.1 | 12,198 | 66 | 132,903 |
| Zambia | 17.09 | 3.9 | 6,008 | 38 | 5,521 |
| Netherlands | 17.04 | 51 | 4,652 | 83 | 594,534 |
| Guatemala | 16.91 | 7.9 | 8,746 | 28 | 12,837 |
| Ecuador | 16.62 | 11.1 | 10,081 | 31 | 28,914 |
| Zimbabwe | 16.53 | 2 | 6,191 | 22 | 5,433 |
| Cambodia | 16.01 | 3.7 | 1,611 | 21 | 37,634 |
| Mean | 83.77 | 18.12 | 5052.70 | 40.22 | 276960.09 |
| Max | 1339.18 | 57.4 | 12198 | 83 | 4092139 |
| Min | 16.01 | 1.1 | 1279 | 12 | 155 |