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 spreadsheet. 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? 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?

Question

Want to see the full answer?

Answer 1

Question

Chapter 8, Problem 1DAP

To determine

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 spreadsheet.

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?

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?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

One short paper is optional and you can earn up to 5 additional percentage points towards your final course grade as extra credit. Find a recent article (published in 2024) from a newspaper, magazine or academic journal (either print or online) about economics, business or social science which makes use of some of the statistical concepts you have learned in this course. Then write a short analysis explaining how what you learned in this course applies to what is discussed in the article. Good sources for articles would be The Wall Street Journal, Business Week or The Economist, but you can also find applicable articles in the San Francisco Chronicle, the New York Times, or other general newspapers or news magazines.

Please help me don't use AI help by yourself

Write a summary of the article "Are Emily and Greg more employable than Lakisha and Jamal? A field experiment on labor market discrimination" by Bertrand and Mullainathan (2004). 1200 words aproximately. In the first part of your summary, address the following questions based on the article: 1. What is the research question, and why is it important? 2. What are the main contributions of this study to the literature? 3. What empirical method is used to address the research question? What are the key assumptions for the method? 4. What data are used in the empirical analysis? 5. What are the main findings and conclusions of the paper? In addition to answering these questions, add your own comments, thoughts, or criticisms. For example, you can consider whether you are convinced by the methodology or results and explain why. You can discuss the main advantages of the paper, as well as its main drawbacks or limitations. You may also suggest potential areas for future research that could…