Data on US trade statistics

Data on US trade statistics

What does the US trade, how much and with whom? This assignments asks you to investigate these issues by looking at some relevant data. Specifically, the assignment is to find relevant data, create a chart in a spreadsheet program, post it here, and briefly discuss its import.

Go to FRED (Links to an external site.) or the BEA (Links to an external site.); the former has US trade statistics here  (Links to an external site.), the latter here (Links to an external site.). (The FRED data is drawn from the BEA, but organized and presented slightly differently.) You can choose your own time series to present, but might consider one of the following:

Imports and/or exports as a share of GDP;
trade balance as a share of GDP;
trade balance excluding petroleum products (see, for example, line 83 and 84 here (Links to an external site.))
import or export shares by major countries (i.e., Canada, Mexico, China, EU … )
import or export shares by major product group.
The longer the time series, the more telling it is! Below are a couple of how-to videos. In the first one, I show how to create a chart in Excel via FRED. I’m trying to be brief, so please remember that you should carefully label your chart!

the links for videos
1- (Links to an external site.)
Here is an updated “how-to” video on the process of inline embedding pictures: 1) Create a screenshot of your chart. 2) Click on your name on the very top right in Canvas. 3) Browse to “Files”. 4) Upload the image. 5) Browse to the thread, click in “Reply” box, and “Embed Image.”
2- (Links to an external site.)


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *