Create a pivot table showing the count of the number of loans rejected in each of the 11 length of employment categories:

Create a pivot table showing the count of the number of loans rejected in each of the 11 length of employment categories: <1 year, 1 year, 2 years, etc to 10+ years.
February 10, 2021 No Comments Assignment Assignment help

���Scenario: “analyze data that has been provided from a client called Lending Club which is a peer-to-peer lending company, facilitating borrowing and lending of unsecured loans between $1,000 and $35,000. Investors can invest in a loan(s) and earn money on interest. Lending Club makes money through origination fees from borrowers and a service fee from investors. Since 2007, thousands of borrowers have borrowed twenty billion in funds through the Lending Club.” •Review/ Reference the “dataset for loans that have been turned down” provided 1.Create a pivot table showing the count of the number of loans rejected in each of the 3 Debt-to Income ratio categories: High, Mid and Low. Rename the sheet Debt to Income. 2.Create a pivot table showing the count of the number of loans rejected in each of the 11 length of employment categories: <1 year, 1 year, 2 years, etc to 10+ years. Rename the sheet Length of Employment. 3.Create a pivot table showing the count of the number of loans rejected in each of the 6 credit score categories: Excellent, Very Good, Good, Fair,Poor, Very Bad. Rename the sheet Credit Score. 4.Create a pivot table showing the count of the number of loans rejected that had a credit score of Excellent, worked 10+ years, and had a low to debt to income ratio.