ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database, and find data on Personal Consumption
Expenditures (PCEC), Personal Consumption Expenditures: Durable Goods (PCDG),
Personal Consumption Expenditures: Nondurable Goods (PCND), and Personal
Consumption Expenditures: Services (PCESV).
a. Using the most recent data: What percentage of total household expenditures is devoted
to the consumption of goods (both durable and nondurable goods)?
b. Given these data, which specific component of household expenditures would be most
impacted by a reduction in overall household spending? Explain.
2. Go to the St. Louis Federal Reserve FRED database, and find data on Real Private Domestic
Investment (GPDIC1), a measure of the real interest rate; the 10-year Treasury Inflation-
Indexed Security, TIIS (FII10); and the spread between Baa corporate bonds and the 10-year
U.S. treasury (BAA10YM), a measure of financial frictions. For (FII10) and (BAA10YM),
convert the frequency setting to “quarterly,” and download the data into a spreadsheet. For
each quarter, add the (FII10) and (BAA10YM)series to create ri, the real interest rate for
investments for that quarter. Then calculate the change in both investment and ri as the
change in each variable from the previous quarter.
a. For the eight most recent quarters of data available, calculate the change in investment
from the previous quarter, and then calculate the average change over the eight most
recent quarters.
b. Assume there is a one-quarter lag between movements in ri and changes in investment; in
other words, if ri changes in the current quarter, it will affect investment in the next
quarter. For the eight most recent lagged quarters of data available, calculate the one-
quarter-lagged average change in ri.
c. Take the ratio of your answer from part (a) divided by your answer from part (b). What
does this value represent? Briefly explain.
coefficient on the investment function; that is, for every one percentage point increase in