1.The International Trade Administration, a US agency, provides detailed data on US import and exports. Visit http://tse ht.export.gov/tse/tsehome.aspx and click on National Trade Data, then select US Trade by Product Patterns of US Merchandise Trade.After doing this, you will see a colored map of the world and a list of countries. On that screen on top, you will see a menu bar, click on Download, then a screen will pop up, select cross tab (in CSV format). This will open an excel file. a.According to the most recent data, which are the top ten buyers of American goods? Visually present each country's exports and their relative importance. Describe what the data show. b.Using the most current data, organize the top 50 countries in regions, for example Africa, and visually present the value of their purchases by region and show their relative importance. Describe what the data show. 2.Follow the instructions in question 1, but now find import data a.According to the most recent data, which are the top ten sellers to the US? Visually present each country's exports and their relative importance. Describe what the data show. b.Using the most current data, cluster countries in regions and visually present the value of their sells by region and show their relative importance. Describe what the data show. 3.Now use data overtime and show how exports to each of the top ten countries has changed overtime and if there have been changes in the ranking as buyers of US goods. Describe what you find. 4.Use import data overtime and show how imports from each of the top ten countries has changed overtime and if there have been changes in the ranking as sellers to US. Describe what you find. Please answer these questions, thank you