\fQuestion 1: The World Trade Organization (WTO) Report (Part I) [48 marks] The World Trade Organization (WTO) asks you to study the exports of goods, in abso- lute value, for the year 2018. In order to answer specic questions that they have, you need to download the Excel le titled ExceLAssignmentI. a. Go to the sheet titled Most Exporting Coantries. Bank the countries in descending order, in terms of exports. Look at the rst 10 countries. What do you observe that is odd? [4 marks] b. Take the odd row and remove it at the end of the list. Copy the rst 10 coun- tries and their exporting values (the last column) and paste them in the sheet titled It? Largest. Make sure that for a given row, the country and its location agree (if not, you made a mistake). Make a table with all four columns in your Word le (omit the row with the name Other). Comment the table. [4 marks] c. The WTO has added all the other countries together under the name Other in order to analyse all the countries. Explain why this is not a good idea. Once you are done, you can delete that row and focus only on the 10 most exporting countries. [4 marks] d. How many cases do we have? What are the variables and what types are they? Which variables are a label? [4 marks] e. The WTO wants to know which countries depend the most on their exports. Is the total amount of exports the best measure? If you answer yes, explain. If you answer no, explain and give another measure (Hint: a ratio with the exports as the numerator). How do we call a variable that combines several variables? [4 marks] f. Go to the sheet titled New Variable. Bank the countries in descending order. Copy the rst 10 countries and their values and paste them in the sheet titled Big 10. Make sure that for a given row, the country and its location agrees (if not, you made a mistake). Make a table with all four columns in your Word le. Comment the table and compare it with the table in b. [4 marks] g. Copy the sheet titled 10 Largest, move the new sheet after the sheet titled Big 10 and name it Bar graphs. Replace the column with the variable Location for the variable percent. A cell should calculate the percentage of exports done by the country at that row relative to the sum of exports for the 10 most exporting countries. Make a table with all four columns in your Word le. Comment the table. [4 marks] h. Make two bar graphs (one with the values and one with the percents) and put them in your Word le. Comment the graphs. [4 marks] i. Copy the sheet titled 16' Largest, move the new sheet after the sheet titled Bar graphs and name it Pie chart. Replace the column with the variable Location for the variable percent. Make a pie chart and put it in your Word le. Compare the pie chart with the bar graphs. [4 marks] j. Copy the sheet titled 10 Largest, move the new sheet after the sheet titled Pie chart and name it Histogram. Make a histogram (with 4 bins) and put it in your word le. Comment the histogram. What can you conclude about the distribution? [4 marks] k. Go to the sheet titled Time series and plot the evolution of the exports in the United States over time. Put it in your Word le. Comment the graph. What can explain the short period of decreased exports? [4 marks] 1. Copy the sheet titled Time series, move the new sheet after the sheet titled Time series and name it Normal quantiie plot. Generate a Normal quantile plot for the time series. Add the graph to the Word le. What are the steps required to generate this graph? Is the distribution Normal? Comment your graph. [4 marks] \f70 El Salvador 8846722.046 8.846722046 71 Equatorial Guinea 1462808.686 1.462808686 72 Eritrea 489189.8157 0.489189816 73 Estonia 20800007.05 20.80000705 74 Ethiopia(excludes Eritrea) 12066415.21 12.06641521 75 Faeroe Islands 2044054.467 2.044054467 76 Falkland Island 254484.5848 0.254484585 77 Fiji 2554747.272 2.554747272 78 Finland 75830485.66 75.83048566 79 Fr. So. Ant. Tr 40458.42118 0.040458421 80 France 645644053.3 645.6440533 81 Free Zones 4467374.147 4.467374147 82 French Polynesia 2460177.857 2.460177857 83 Gabon 3154616.82 3.15461682 84 Gambia, The 1485978.617 1.485978617 85 Georgia 11442516.94 11.44251694 86 Germany 1183472388 1183.472388 87 Ghana 17462370.24 17.46237024 88 Gibraltar 17137176.77 17.13717677 89 Greece 55992627.17 55.99262717 90 Greenland 1541030.853 1.541030853 91 Grenada 296001.8967 0.296001897 92 Guam 1162052.391 1.162052391 93 Guatemala 17544991.85 17.54499185 94 Guinea 5678398.9 5.6783989 95 Guinea-Bissau 511502.1774 0.511502177 96 Guyana 1415752.292 1.415752292 97 Haiti 3571375.179 3.571375179 98 Heard Island and Mcdonald Isla 618.289672 0.00061829 99 Holy See 108772.5441 0.108772544 100 Honduras 11237587.47 11.23758747 101 Hong Kong, China 702937865.3 702.9378653 102 Hungary 114016579.2 114.0165792 103 Iceland 10886810.05 10.88681005 104 India 426575606.4 426.5756064104 India 426575606.4 426.5756064 105 Indonesia 182167437 182.167437 106 Iran, Islamic Rep. 62702277.1 62.7022771 107 Iraq 48726307.16 48.72630716 108 Ireland 88592318.2 88.5923182 109 Israel 97362489.2 97.3624892 110 Italy 474395351.9 474.3953519 111 Jamaica 5582969.577 5.582969577 112 Japan 657990989.2 657.9909892 113 Jordan 23696492.31 23.69649231 114 Kazakhstan 44854263.57 44.85426357 115 Kenya 20466362.65 20.46636265 116 Kiribati 104677.7971 0.104677797 117 Korea, Dem. Rep. 2324979.439 2.324979439 118 Korea, Rep. 487388966.1 487.3889661 119 Kuwait 40542618.74 40.54261874 120 Kyrgyz Republic 10537966.91 10.53796691 121 Lao PDR 6524789.122 6.524789122 122 Latvia 23687046.91 23.68704691 123 Lebanon 28252423.74 28.25242374 124 Lesotho 1536009.644 1.536009644 125 Liberia 10602916.61 10.60291661 126 Libya 18277158.58 18.27715858 127 Lithuania 32966835.35 32.96683535 128 Luxembourg 26859365.23 26.85936523 129 Macao 13484448.31 13.48444831 130 Macedonia, FYR 14692094.38 14.69209438 131 Madagascar 4074785.749 4.074785749 132 Malawi 1719045.684 1.719045684 133 Malaysia 227287623.2 227.2876232 134 Maldives 2259251.95 2.25925195 135 Mali 5061682.135 5.061682135 136 Malta 18702610.4 18.7026104 137 Marshall Islands 15978571.14 15.97857114136 Malta 18702610.4 18.7026104 137 Marshall Islands 15978571.14 15.97857114 138 Mauritania 3970154.705 3.970154705 139 Mauritius 6230351.775 6.230351775 140 Mexico 465506125 465.506125 141 Micronesia, Fed. Sts. 135254.8356 0.135254836 142 Moldova 9225503.967 9.225503967 143 Mongolia 5761103.609 5.761103609 144 Montenegro 4566845.199 4.566845199 145 Montserrat 31831.04776 0.031831048 146 Morocco 70058469.31 70.05846931 147 Mozambique 10524169.52 10.52416952 148 Myanmar 25821455.99 25.82145599 149 Namibia 5803073.217 5.803073217 150 Nauru 125307.1744 0.125307174 151 Nepal 10691676.3 10.6916763 152 Netherlands 630627678.9 630.6276789 153 New Caledonia 3581067.356 3.581067356 154 New Zealand 44120362.73 44.12036273 155 Nicaragua 4984374.957 4.984374957 156 Niger 1549411.963 1.549411963 157 Nigeria 56768175.51 56.76817551 158 Niue 31614.69364 0.031614694 159 Norfolk Island 26394.58675 0.026394587 160 Northern Mariana Islands 179603.3983 0.179603398 161 Norway 145101353.4 145.1013534 162 Occ.Pal. Terr 1273526.12 1.27352612 163 Oman 39221519.51 39.22151951 164 Other Asia, nes 271188739.5 271.1887395 165 Pakistan 59881221.2 59.8812212 166 Palau 113997.6011 0.113997601 167 Panama 45005862.33 45.00586233 168 Papua New Guinea 4736555.332 4.736555332 169 Paraguay 11688729.98 11.68872998 170 Peru 42580192.08 42.58019208 171 Philippines 134394477.5 134.3944775\f206 Suriname 1626197.385 1.626197385 207 Swaziland 1777947.306 1.777947306 208 Sweden 154199833.9 154.1998339 209 Switzerland 457176158.6 457.1761586 210 Syrian Arab Republic 7327892.648 7.327892648 211 Tajikistan 3857312.409 3.857312409 212 Tanzania 12445366.61 12.44536661 213 Thailand 220712021 220.712021 214 Togo 15843945.07 15.84394507 215 Tokelau 34929.25368 0.034929254 216 Tonga 214125.6235 0.214125624 217 Trinidad and Tobago 6297482.101 6.297482101 218 Tunisia 34663840.79 34.66384079 219 Turkey 288783369.3 288.7833693 220 Turkmenistan 2978214.764 2.978214764 221 Turks and Caicos Isl. 508659.4357 0.508659436 222 Tuvalu 88186.30569 0.088186306 223 Uganda 4400397.217 4.400397217 224 Ukraine 81780661.75 81.78066175 225 United Arab Emirates 243936925.3 243.9369253 226 United Kingdom 650900930.8 650.9009308 227 United States 2787745305 2787.745305 228 United States Minor Outlying I 27127.98017 0.02712798 229 Unspecified 653386945.5 653.3869455 230 Uruguay 13517876.41 13.51787641 231 Uzbekistan 19552255.45 19.55225545 232 Vanuatu 331104.564 0.331104564 233 Venezuela 11945060.8 11.9450608 234 Vietnam 271750274.8 271.7502748 235 Wallis and Futura Isl. 57060.47508 0.057060475 236 Western Sahara 16492.53059 0.016492531 237 Yemen 9217708.511 9.217708511 238 Zambia 6090196.084 6.090196084 239 Zimbabwe 4146118.883 4.146118883The different points that will be mentioned need to be respected. Otherwise, you will lose points. You will have to submit two files: an Excel file as well as a pdf file (generated from your Word file). The Excel file will show the TAs how you arrive to the results. The name of your two files should be as follows Assignment1_yourlastname_yourfirstname_yourstudentID. The submission is done through OnQ under Assessments/ Assignments/Excel/Assignment#1. Do not forget to add a presentation page to your Word file. A table that is generated in your Word file needs to have a title. Every column needs a name. Every row needs a name. A graph that is added to your Word file needs to have a title. The horizontal axis needs a name. The vertical axis needs a name. Add a legend to your graph when possible. Be as thorough as possible. Be as clear and as clean as possible. Otherwise, points will be taken off