Question
Download the rejected loans data set of LendingClub data titled RejectStatsA Ready and do an Excel PivotTable by state and figure out the number of
Download the rejected loans data set of LendingClub data titled "RejectStatsA Ready" and do an Excel PivotTable by state and 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.
| Row Labels | Sum of Rejected Loans | Sum of Amount Requested |
| AK | 662622535 | 23583550 |
| AL | 4276465865 | 136523708 |
| AR | 3187954242 | 97256374 |
| AZ | 5361208037 | 183993870 |
| CA | 33419361825 | 1212707597 |
| CO | 4342593430 | 164226517.6 |
| CT | 4155935566 | 140248633 |
| DC | 585235888 | 18196438 |
| DE | 879834551 | 28800520 |
| FL | 19507825666 | 651600737.3 |
| GA | 9064969702 | 310393599.3 |
| HI | 1551968762 | 56545565 |
| IA | 1366811 | 978425 |
| ID | 1155807 | 452125 |
| IL | 10430037517 | 374269150.1 |
| IN | 391725897 | 8842275 |
| KS | 2330154510 | 75011078 |
| KY | 3396206481 | 112405365 |
| LA | 3646033997 | 121807730.1 |
| MA | 6607208414 | 210819486.7 |
| MD | 5792939561 | 191211718.5 |
| ME | 6130452 | 784150 |
| MI | 6850863545 | 230336258.8 |
| MN | 3494199788 | 122287428 |
| MO | 4690514238 | 161851793 |
| MS | 32847008 | 3144600 |
| MT | 722759041 | 26011000 |
| NC | 7704423606 | 228905326.6 |
| ND | 2540437 | 312750 |
| NE | 14797913 | 1335693 |
| NH | 1302480667 | 49667389.95 |
| NJ | 9138921263 | 344114852.8 |
| NM | 1472392658 | 51237273.3 |
| NV | 3348601787 | 107723949 |
| NY | 20196841031 | 707027048.7 |
| OH | 9249348609 | 308530025.4 |
| OK | 2755013808 | 92305671 |
| OR | 2407116213 | 85064964.17 |
| PA | 10523774354 | 377824743.5 |
| RI | 1260669948 | 40080044 |
| SC | 3816844820 | 130611006.6 |
| SD | 580418002 | 19855325 |
| TN | 40383147 | 2793175 |
| TX | 21117696416 | 735614230.1 |
| UT | 1735583539 | 62697554.2 |
| VA | 7688322379 | 274119143.7 |
| VT | 676718325 | 21988075 |
| WA | 4689062588 | 171985466 |
| WI | 3366388027 | 118931727.6 |
| WV | 1548377207 | 53238104.53 |
| WY | 558439817 | 20994525 |
| Grand Total | 2.50585E+11 | 8671247757 |
1. Put the following states in order of their loan rejection percentage based on the count of rejected loans (from high (1) to low (11)).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting Essentials For Hospitality Managers
Authors: Chris Guilding
3rd Edition
0415841097, 978-0415841092
