Mishkin • Instructor’s Manual for The Economics of Money, Banking, and Financial Markets, Twelfth Edition 117
ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database and find data on the percent of value of
loans secured by collateral for all commercial and industrial loans (ESANQ) and the net
percentage of domestic banks tightening standards for commercial and industrial loans to
large and middle-market firms (DRTSCILM). Download the data into a spreadsheet.
a. Calculate the average, over the most recent four quarters and the four quarters prior to
that, for the bank standards indicator and the “percent of loans secured by collateral”
indicator. Do these averages behave as you would expect?
See summary table below for the periods of 2016:Q2 to 2017:Q1 and 2015:Q2 to
2016:Q1. There seems to be an direct relationship between percent value of loans
Percent Value of C&I
Loans Collateralized,
Average
Net Tightening of C&I
Lending Standards,
Average
2016:Q2 to 2017:Q1 62.0 5.8
b. Use the Data Analysis tool in Excel to calculate the correlation coefficient for the two
data series from 1997:Q3 to the most recent quarter of data available. What can you
conclude about the relationship between collateral and bank C&I lending standards? Is
this result consistent with efforts to reduce asymmetric information?
The correlation coefficient between the two indicators from 1997:Q2 to 2017:Q1is –0.24,