Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the employment length. Because our analysis requires risk scores, debt-to-income data, and employment length, we need to make sure each of them has valid data. a. Sort the file based on employment length and remove those observations (the complete row or record) that have a missing score (“NA”) or a score of zero. b. Sort the file based on debt-to-income and remove those observations (the complete row or record) that have a missing score, a score of zero, or a negative score. c. 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. d. There should now be 669,993 observations. Any thoughts on what biases are imposed when we remove observations? Is there another way to do this? e. Run a PivotTable analysis to show the number of Excellent Risk Scores but High DTI Bucket loans in each Employment year bucket. Any interpretation of why these loans were declined based on employment length?

Data Analytics For Accounting

19th Edition

ISBN: 9781260375190

Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie

Publisher: Mcgraw-hill Education,

See similar textbooks

Videos

Textbook Question

Chapter 1, Problem 7P

Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the employment length. Because our analysis requires risk scores, debt-to-income data, and employment length, we need to make sure each of them has valid data.

a. Sort the file based on employment length and remove those observations (the complete row or record) that have a missing score (“NA”) or a score of zero.
b. Sort the file based on debt-to-income and remove those observations (the complete row or record) that have a missing score, a score of zero, or a negative score.
c. 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.
d. There should now be 669,993 observations. Any thoughts on what biases are imposed when we remove observations? Is there another way to do this?
e. Run a PivotTable analysis to show the number of Excellent Risk Scores but High DTI Bucket loans in each Employment year bucket. Any interpretation of why these loans were declined based on employment length?

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 1, Problem 6P

Chapter 2, Problem 1MCQ

Students have asked these similar questions

Give me proper answer with calculation otherwise i give downvote Note:- Please avoid using ChatGPT and refrain from providing handwritten solutions; otherwise, I will definitely give a downvote. Also, be mindful of plagiarism. Answer completely and accurate answer. Rest assured, you will receive an upvote if the answer is accurate.

Can i please get help with this please? I filled in the blanks with the options to show what we are working with..Also please help me understand why you picked what you did so i may study correctly , thank you. There is only 1 table second one is just showing more options, options not shown are:long term notes payable, ace capital, ace withdrawals,construction revenue, construction revenue, depreciation expense-equipment,wages expense, interest expense, insurance expense,rent expense,supplies expense, property tax expense, repair expense and utilities expense. ACE CONSTRUCTION COMPANY Unadjusted Trial Balance June 30 Number Account Title Debit Credit 101 Cash $ 16,500 126 Supplies 10,000 128 Prepaid insurance 7,000 167 Equipment 144,770 168 Accumulated depreciation—Equipment $ 24,500 201 Accounts payable 5,400 203 Interest payable 0 208 Rent payable 0 210 Wages payable 0 213 Property taxes payable 0 251 Long-term notes payable…

Please give me correct answer and full explanation with calculation. Note:- Please avoid using ChatGPT and refrain from providing handwritten solutions; otherwise, I will definitely give a downvote. Also, be mindful of plagiarism. Answer completely and accurate answer. Rest assured, you will receive an upvote if the answer is accurate.

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Solution Summary: The author analyzes the number of Excellent Risk Scores but High DTI Bucket loans in each Employment year bucket. They explain why these loans were rejected on the basis of employment length.

Videos

Want to see the full answer?

Chapter 1 Solutions