Can you please provide me with a step by step process for solving these problems with excel? I am not understanding how to use excel for these problems. Screenshots with highlights and numbered steps would be most helpful. I would like to know how you thought this process through so that I can do it on my own next time. Thank you.

Excel Assignment 3 There are three data sets for you to analyze. Data Set 1 (Download Excel File \"Coffee Exports\") Data set 1 has coffee exports (thousands of 60-kilo bags) for December 2000 and total exports for 2001 for 42 coffee exporting countries excluding the three largest exporters (Brazil, Colombia, and Vietnam). A scatterplot is shown below. Total 2001 Exports 5000.00 4000.00 3000.00 2000.00 1 000.00 0.00 0.00 100.00 200.00 300.00 400.00 Dec 2MB Exports Commodity traders would like to use December export gures 'om a particular country to predict total exports from that country in the coming year. a) Use the data to come up with an equation for predicting total 2001 exports from December 2000 exports. b) Assume that the equation you found in part \"a\" will apply to any year. If the coffee export of a country in December is 100, within what range would we expect to nd the total exports for that country to fall in the coming year. Coffee Exports Dec Exports Total Exports Country 2000 2001 Venezuela 0.00 180.30 Sri_Lanka 0.00 1.83 Nigeria 0. 13 3.39 Philippines 0.30 3.01 Togo 0.76 193.05 Paraguay 1.00 1 1.00 Sierra_Leone 1.09 26.31 Ghana 1.43 34.16 Jamaica 2.09 29.47 Angola 2.45 17.25 Zimbabwe 3.15 93.64 Zambia 4.26 82.4 Dominican_Republic 4.58 106.44 Rwanda 5.37 294.60 Bolivia 7.00 124.63 Haiti 8.00 73.00 Guinea 8.34 47.68 Malawi 9.27 63.71 Central_African_Republic 9.88 109.2 Cameroon 10.68 1169.71 Panama 15.87 $6.93 Cub 20. 1 99.53 Congo 23.37 199.33 Thailand 29.77 1 167.08 Madagascar 32.55 294.83 Burundi 41.06 303.18 Papua_New_Guinea 58.66 1079.98 Ecuado 70.49 754.29 Nicaragua 72.83 1364.59 Ethiopia 77.66 1390.99 Kenya 97.65 982.44 Tanzania 102.36 866.16 EL_Salvador 118.9 1521.64 Costa_Rica 128.99 2054.66 India 40.78 3964.27 Peru 152.49 2396.00 Cote_d.Ivoire 175.98 3521.39 Honduras 176.98 2391.61 Uganda 232.43 3053.30 Indonesia 260.72 4439.59 Mexico 318 .31 3408.33 Guatemala 326.98 4110.38 Cancel Print