Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economics

Authors: David Colander

7th Edition

0073402869, 9780073402864

More Books

Students also viewed these Economics questions

Question

What is the Systems School of thought in Organizational Behavior?

Answered: 1 week ago

Question

How easy the information is to remember

Answered: 1 week ago

Question

The personal characteristics of the sender

Answered: 1 week ago