explore data analysis in more depth. Using EXCEL, complete the following assignment:
Yuzhi Zhao
Week2-CountryData.xlsSampCountries
| Country | LandArea | Population | Energy | Rural | Military | Health | HIV | Internet Access | Developed | BirthRate | ElderlyPop | LifeExpectancy | Government |
| (source: World Health Organization Statistics, 2015) | (km^2) | (million) | (millions of kg of oil equivalent) | (% of population) | (% of population) | (propability of dying during adult ages of 30-70) | (% of population infected) | (% of population) | (0-3=undeveloped, under-developed, developing, developed) | (annual number of births per 1,000 persons) | (% population over 65) | (years) | (type) |
| Argentina | 2,736,690 | 39.883 | 76,359 | 8.0 | 0.00 | 13.7% | 0.5 | 28.1 | 2 | 17.27 | 10.511 | 75.33 | Republic |
| Armenia | 28,480 | 3.077 | 2,997 | 36.1 | 16.06 | 7.2% | 0.1 | 6.2 | 1 | 15.30 | 11.563 | 73.54 | Republic |
| Australia | 7,682,300 | 21.432 | 130,113 | 11.3 | 7.71 | 17.1% | 0.1 | 70.8 | 3 | 13.80 | 13.415 | 81.40 | Constitutional Monarchy |
| Azerbaijan | 82,620 | 8.68 | 13,367 | 48.1 | 22.88 | 2.5% | 0.1 | 28.2 | 1 | 17.80 | 6.768 | 70.18 | Republic |
| Belgium | 30,280 | 10.708 | 58,583 | 2.6 | 2.75 | 14.8% | 0.2 | 70.5 | 3 | 11.70 | 17.243 | 80.43 | Constitutional Monarchy |
| Bolivia | 1,083,300 | 9.694 | 5,694 | 34.4 | 0.00 | 8.2% | 0.2 | 10.8 | 1 | 27.10 | 4.664 | 65.68 | Republic |
| Bosnia and Herzegovina | 51,200 | 3.773 | 5,990 | 52.6 | 3.37 | 14.0% | 0.0 | 34.7 | 1 | 9.10 | 13.788 | 75.11 | Republic |
| Central African Republic | 622,980 | 4.339 | - 0 | 61.4 | 0.00 | 11.0% | 5.1 | 0.4 | 0 | 35.42 | 3.880 | 46.96 | Republic |
| Chile | 743,530 | 16.804 | 31,446 | 11.6 | 17.94 | 15.6% | 0.4 | 32.5 | 2 | 14.94 | 8.755 | 78.61 | Republic |
| Costa Rica | 51,060 | 4.519 | 4,897 | 36.7 | 0.00 | 26.1% | 0.3 | 32.3 | 1 | 16.68 | 6.183 | 78.92 | Republic |
| Djibouti | 23,180 | 0.849 | - 0 | 12.7 | 0.00 | 15.3% | 2.6 | 2.3 | 0 | 28.44 | 3.166 | 55.39 | Republic |
| El Salvador | 20,720 | 6.134 | 4,882 | 39.3 | 2.86 | 11.9% | 0.8 | 10.6 | 1 | 20.24 | 7.040 | 71.26 | Republic |
| Ethiopia | 1,000,000 | 80.713 | 31,704 | 83.0 | 0.00 | 11.5% | 0.0 | 0.4 | 1 | 38.23 | 3.148 | 55.20 | Republic |
| Fiji | 18,270 | 0.844 | - 0 | 47.6 | 0.00 | 10.2% | 0.1 | 12.2 | 0 | 20.95 | 4.626 | 68.87 | Republic |
| Gambia, The | 10,000 | 1.66 | - 0 | 43.6 | 0.00 | 11.6% | 1.7 | 6.9 | 0 | 36.76 | 2.818 | 55.93 | Republic |
| Guinea | 245,720 | 9.833 | - 0 | 65.6 | 0.00 | 4.3% | 1.4 | 0.9 | 0 | 39.63 | 3.205 | 57.82 | Republic |
| Israel | 21,640 | 7.309 | 22,009 | 8.3 | 17.12 | 10.0% | 0.2 | 47.9 | 3 | 21.50 | 10.042 | 81.00 | Republic |
| Kenya | 569,140 | 38.765 | 18,021 | 78.4 | 8.90 | 5.8% | 6.3 | 8.7 | 1 | 38.77 | 2.658 | 54.24 | Republic |
| Kuwait | 17,820 | 2.728 | 26,291 | 1.6 | 14.42 | 6.1% | 0.0 | 36.7 | 3 | 17.71 | 2.087 | 77.97 | Constitutional Monarchy |
| Latvia | 62,190 | 2.266 | 4,484 | 31.9 | 6.40 | 10.2% | 0.6 | 63.2 | 2 | 10.60 | 17.186 | 72.42 | Republic |
| Lesotho | 30,360 | 2.049 | - 0 | 74.5 | 3.14 | 8.2% | 23.6 | 3.6 | 0 | 28.94 | 4.750 | 44.99 | Constitutional Monarchy |
| Libya | 1,759,540 | 6.294 | 18,221 | 22.5 | 0.00 | 5.5% | 0.0 | 5.1 | 2 | 23.30 | 4.130 | 74.33 | NA |
| Lithuania | 62,670 | 3.358 | 9,177 | 33.0 | 4.85 | 12.8% | 0.1 | 54.6 | 2 | 10.40 | 15.968 | 71.81 | Republic |
| Luxembourg | 2,590 | 0.489 | 4,119 | 17.6 | 0.00 | 13.7% | 0.3 | 80.9 | 3 | 11.50 | 14.037 | 80.09 | Constitutional Monarchy |
| Malta | 320 | 0.412 | 819 | 5.7 | 1.51 | 12.3% | 0.1 | 49.5 | 2 | 10.00 | 14.017 | 79.43 | Republic |
| Mexico | 1,943,950 | 106.35 | 180,605 | 22.8 | 0.00 | 15.0% | 0.3 | 21.9 | 1 | 18.33 | 6.225 | 75.07 | Republic |
| Moldova | 32,890 | 3.633 | 3,150 | 58.2 | 1.86 | 13.0% | 0.4 | 23.4 | 1 | 12.32 | 11.137 | 68.44 | Republic |
| Namibia | 823,290 | 2.13 | 1,752 | 63.2 | 0.00 | 12.1% | 13.7 | 5.3 | 1 | 27.56 | 3.592 | 61.01 | Republic |
| New Zealand | 263,310 | 4.269 | 16,935 | 13.4 | 0.00 | 18.3% | 0.1 | 71.4 | 3 | 15.15 | 12.543 | 80.35 | Constitutional Monarchy |
| Niger | 1,266,700 | 14.704 | - 0 | 83.5 | 0.00 | 14.8% | 0.8 | 0.5 | 0 | 53.54 | 1.979 | 51.40 | Republic |
| Norway | 305,470 | 4.768 | 29,670 | 22.5 | 4.22 | 16.7% | 0.1 | 90.5 | 3 | 12.70 | 14.646 | 80.59 | Constitutional Monarchy |
| Oman | 309,500 | 2.785 | 16,443 | 28.4 | 0.00 | 4.9% | 0.1 | 20.0 | 2 | 21.96 | 2.885 | 75.91 | Absolute Monarchy |
| Panama | 74,340 | 3.399 | 2,899 | 26.8 | 0.00 | 13.5% | 0.9 | 27.6 | 1 | 20.64 | 6.380 | 75.66 | Republic |
| Peru | 1,280,000 | 28.837 | 14,710 | 28.6 | 6.50 | 15.6% | 0.4 | 24.7 | 1 | 21.11 | 5.731 | 73.26 | Republic |
| Philippines | 298,170 | 90.348 | 41,067 | 35.1 | 4.90 | 6.1% | 0.1 | 6.2 | 1 | 24.73 | 4.115 | 71.83 | Republic |
| Portugal | 91,470 | 10.622 | 24,159 | 40.5 | 4.80 | 15.4% | 0.5 | 44.4 | 2 | 9.80 | 17.501 | 78.52 | Republic |
| Russian Federation | 16,376,870 | 141.95 | 686,757 | 27.2 | 16.29 | 9.2% | 1.0 | 32.0 | 3 | 12.10 | 13.295 | 67.85 | Republic |
| Samoa | 2,830 | 0.179 | - 0 | 77.0 | 0.00 | 14.9% | 0.0 | 5.0 | 0 | 23.51 | 4.805 | 71.75 | Republic |
| Saudi Arabia | 2,000,000 | 24.807 | 161,600 | 17.6 | 0.00 | 8.4% | 0.0 | 31.3 | 3 | 23.42 | 2.869 | 73.12 | Absolute Monarchy |
| Slovenia | 20,140 | 2.021 | 7,735 | 51.4 | 4.08 | 12.9% | 0.1 | 57.5 | 3 | 10.80 | 16.027 | 78.77 | Republic |
| Solomon Islands | 27,990 | 0.511 | - 0 | 82.0 | 0.00 | 14.4% | 0.0 | 2.0 | 0 | 30.45 | 3.065 | 66.26 | Constitutional Monarchy |
| South Africa | 1,214,470 | 48.793 | 134,489 | 39.3 | 4.34 | 10.4% | 17.9 | 8.6 | 2 | 22.04 | 4.369 | 51.48 | Republic |
| Sri Lanka | 62,710 | 20.156 | 8,935 | 84.9 | 18.54 | 7.9% | 0.1 | 5.8 | 1 | 18.80 | 7.254 | 74.13 | Republic |
| Turkmenistan | 469,930 | 5.044 | 18,814 | 51.4 | 0.00 | 7.0% | 0.0 | 1.5 | 1 | 21.93 | 4.310 | 64.82 | Republic |
| Uganda | 197,100 | 31.657 | - 0 | 87.0 | 17.04 | 10.5% | 6.4 | 7.9 | 0 | 46.15 | 2.562 | 52.67 | Republic |
| Ukraine | 579,320 | 46.258 | 136,143 | 32.0 | 7.16 | 8.6% | 1.1 | 22.5 | 2 | 11.00 | 15.904 | 68.25 | Republic |
| United Arab Emirates | 83,600 | 4.485 | 58,439 | 22.1 | 0.00 | 8.9% | 0.0 | 72.0 | 3 | 14.00 | 1.007 | 77.75 | Absolute Monarchy |
| United Kingdom | 241,930 | 61.407 | 208,450 | 10.1 | 5.77 | 15.1% | 0.2 | 78.2 | 3 | 12.90 | 16.302 | 79.60 | Constitutional Monarchy |
| Uzbekistan | 425,400 | 27.314 | 50,501 | 63.2 | 0.00 | 8.6% | 0.1 | 9.0 | 1 | 21.68 | 4.570 | 67.76 | Republic |
| Vanuatu | 12,190 | 0.234 | - 0 | 75.2 | 0.00 | 13.5% | 0.0 | 7.3 | 0 | 30.20 | 3.280 | 70.29 | Republic |
