Download the rejected loans dataset of LendingClub data titled “RejectStatsA Ready” from the Connect website and do an Excel PivotTable by state; then figure out the number of rejected applications for each state. Reorder these and make a graph ordering the states and the number of rejected loans from highest to lowest. Is there a lot of variability among states?
For Problems 5, 6, and 7, we will be cleaning a data file in preparation for subsequent analysis. The analysis performed on LendingClub data in the chapter was for the years 2007– 2012. For this and subsequent problems, please download the declined loans table for 2013–2014 from the Connect website, https://www.lendingclub.com/info/downloaddata. action.