This preview shows pages 1–2. Sign up to view the full content.
Problem Set 2
Gross Domestic Product
Due: September 6, 2007
GDP = Consumption + Investments + Government Spending + Net Exports
Problem 1:
Graph the GDP (Gross Domestic Product) and its components from 1980 to
2007.
Obtaining the Data:
Go to the Federal Reserve Bank of St. Louis’s website
(
http://research.stlouisfed.org/fred2/
).
Utilize the search bar at the top of the page to find
the data sets (i.g. enter “GDPC1” for the Gross Domestic Product).
Gross Domestic Product – GDPC1
Components:
Consumption  PCECC96
Government Spending – GCEC1
Net Exports – NETEXC
Investments – FPIC1
First download the GDP data set in Excel format.
Then download each GDP component
data set in Excel format.
For each component data set, copy the appropriate values
(excluding the dates) and paste them in the columns directly to the right of the GDP.
This will allow sidebyside analysis.
The Excel spreadsheet should look like this:
Date
GDP
Consumption
Government
Net Exports
Investments
19800101
5221.3
3401.7
1120.8
16.8
703.0
19800401
5115.9
3325.8
1124.3
13.7
641.8
Continued through 2007
Using the data on the Excel spreadsheet, graph the Gross Domestic Product and each its
components on the same graph from 1980 to 2007.
Be sure to use the appropriate type of
graph, label the axis, and title the graph.
Graphing the data using Excel:
1.
Highlight all the filled Excel cells (including the labels, required dates, GDP,
and the components).
2.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 04/07/2008 for the course COMM 180 taught by Professor Achinson during the Spring '05 term at UVA.
 Spring '05
 Achinson

Click to edit the document details