Mishkin • Instructor’s Manual for The Economics of Money, Banking, and Financial Markets, Twelfth Edition 228
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)?
For 2017:Q1, total personal consumption expenditures are $13,191.6 billion, nondurable
consumption is $2787.6 billion, and durables consumption is $1443.2 billion. Thus,
b. Given these data, which specific component of household expenditures would be most
impacted by a reduction in overall household spending? Explain.
Since services are a much larger fraction of consumption than either nondurables or
durable consumption, it would be reasonable to conclude decline in household spending
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.
From 2015:Q1 to 2016:Q4, the average change in ri was –0.01.