ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database, and find data on real government
spending (GCEC1), real GDP (GDPC1), taxes (W006RC-1Q027SBEA), and the personal
consumption expenditure price index (PCECTPI), a measure of the price level. Download all
of the data into a spreadsheet, and convert the tax data series into real taxes. To do this, for
b. Calculate the level change in real government spending and real taxes over the four most
recent quarters of data available, and the four quarters prior to that.
c. Are your results consistent with what you would expect? How do your answers to part (b)
help explain, if at all, your answer to part (a)? Explain using the IS and AD curves.
Government
Spending
Change, $ Bil.
2. Go to the St. Louis Federal Reserve FRED database, and find data on the personal
consumption expenditure price index (PCECTPI), a measure of the price level; real
compensation per hour (COM-PRNFB); the nonfarm business sector real output per hour
(OPHNFB), a measure of worker productivity; the price of a barrel of oil (MCOILWTICO);
a. Calculate the change in the inflation rate over the four most recent quarters of data