Question: iProblem 3 (10 points) In this problem we will once again analyze the data on loan defaults. A credit analyst would like to understand the

iProblem 3 (10 points) In this problem we will once again analyze the data on loan defaults. A credit analyst would like to understand the relationship between loan origination amount, credit scores, and default risk. Bin the data on the Loan Value parameter (Ln_Orig) into quartiles using Data Science. Create an Excel pivot table that shows the proportion of loans by Outcome for each quartile. (i.e., the percentage of quartile 1 loans that defaulted). Note you may need to copy and paste the binned data in order to create a pivot table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock