Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the LendingClub dataset provided in this weeks assignment folder named RejectedLoansAll.xlsx, perform the following procedures: 1) Select all rejected loans with Application Year =
Use the LendingClub dataset provided in this weeks assignment folder named RejectedLoansAll.xlsx, perform the following procedures: 1) Select all rejected loans with Application Year = 2011 and delete the rest of the loans. 2) Construct a new variable (labelled Risk_Score_Bucket) that assigns each loan to one of the six buckets based on their risk scores with the following coding scheme: Excellent: Risk_Score>=800 Very Good: 760<=Risk_Score <800 Good: 700<= Risk_Score <760 Fair: 640<= Risk_Score<700 Poor: 600<= Risk_Score <640 <600
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