extra credit 37

/in /by

Extra Credit:

Part 1 – Federal Reserve Bank of New York Data Analysis: Due May 7th at 11:59pm

In addition, you must log onto Federal Reserve Bank of New York’s Center for Microeconomic Data (https://www.newyorkfed.org/microeconomics/databank.html) and download the Quarterly Report on Household Debt and Credit – choose the excel file labeled Household Debt Statistics by State (1999- 2018). Once you download this excel file open the tab for studentloan_delinq:

  • Create a bar graph showing the student loan delinquencies for all states for last year (2018). Which are the top 6 states with the highest rates of student loan delinquencies for last year? Which state is the highest?
  • Create a new bar graph with the highest 6 states for every 3 years going as far back as the data will let you (i.e 2018, 2015, 2013, 2010, etc). Which state is the highest? Was it the highest over all the years you analyzed? Was the number of delinquencies rising over the years or falling?

Part 2 – One to two- page Analysis: Due May 7th at 11:59pm

In your paper you should include the graphs you created as well as the answers to the questions in part 2. Also include what steps you took get your data and create your graphs. What are your thoughts on the rates of student loan delinquencies? Are they high or low? What about in Maryland- are they on the higher side/average/lower end? What do you think causes higher rates of delinquencies? Do you think the rates will keep increasing? What sort of policies could be implemented to decrease delinquencies? Be sure to cite, using APA , any findings to back your argument and provide a bibliography.

The write up of this assignment must be submitted by 11:59pm on to receive full credit

Extra credit: If you are feeling adventurous, for extra credit on this assignment you can either use PowerBI or Tableau to visualize your graphs and make them look more appealing.