Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

2nd Edition

047116920X, 978-0471169208

More Books

Students also viewed these Accounting questions

Question

Why would a person fear success?

Answered: 1 week ago

Question

Explain the differences between HTTP and HTTPS .

Answered: 1 week ago

Question

In your own words, summarize the primary objectives of unions.

Answered: 1 week ago