Accounting II

Assignment Requirements:

1. Open the 2015 LendingClub Rejected Loans Data Set posted to the Learning Module 6 Assignment #1 tab. 

2. Sort the file based on risk score and remove those observations (the complete row or record) that have a missing score or a score of zero.

3. Assign each risk score to a risk score bucket as in the chapter: classify the sample according to their credit score noted in Exhibit 1-10. Any credit score over 850 classify as “excellent”.

4. Create a PivotTable that shows the number of loans in each risk score bucket (similar to Exhibit 1-11). (7 points)

5. Using the PivotTable from #4, create a PivotChart of your choice. The PivotChart should be appropriate to the data that you are representing. Include appropriate titles and labels. (7 points)

6. Which group had the most rejected loans? (2 points)

7. Which group has the least rejected loans? (2 points)

8. Based on risk scores, what is your interpretation of why these loans were declined? (2 points)