
Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 1, Problem 6P
Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the debt-to-income data. 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 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.
- b. Assign each valid debt-to-income ratio into three buckets (labeled DTI bucket) by classifying each debt-to-income ratio into high (>20 percent), medium (10–20 percent), and low (<10 percent) buckets. Consider using if-then statements to complete this. Or sort the row and manually input.
- c. Run a PivotTable analysis that shows the number of loans in each DTI bucket. Any interpretation of why these loans were declined based on debt-to-income ratios?
Expert Solution & Answer

Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
General Accounting Question Solution with Better method
General Accounting Question Answer need
General Accounting
Chapter 1 Solutions
Data Analytics For Accounting
Ch. 1 - Prob. 1MCQCh. 1 - Prob. 2MCQCh. 1 - Prob. 3MCQCh. 1 - Prob. 4MCQCh. 1 - Prob. 5MCQCh. 1 - Prob. 6MCQCh. 1 - Prob. 7MCQCh. 1 - Prob. 8MCQCh. 1 - Prob. 9MCQCh. 1 - Prob. 10MCQ
Ch. 1 - Prob. 1DQCh. 1 - Give an example of how Data Analytics creates...Ch. 1 - Prob. 3DQCh. 1 - Prob. 4DQCh. 1 - Prob. 5DQCh. 1 - Prob. 6DQCh. 1 - Prob. 7DQCh. 1 - Prob. 8DQCh. 1 - Prob. 9DQCh. 1 - Prob. 10DQCh. 1 - Prob. 11DQCh. 1 - Prob. 12DQCh. 1 - To address the question Will I receive a loan from...Ch. 1 - Download and consider the data dictionary file...Ch. 1 - Download and consider the rejected loans dataset...Ch. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Consider the 2013 declined loan data from...Ch. 1 - Consider the 2013 declined loan data from...
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.Similar questions
- General Accounting Question Solve Now plsarrow_forwardThe balance in the dividends account is closed to:A. CashB. RevenueC. Retained EarningsD. Common Stock needarrow_forwardWhat is the effect of writing off an uncollectible account under the allowance method?A. Increases net incomeB. No effect on total assetsC. Decreases revenueD. Increases expensescorrectarrow_forward
- What is the effect of writing off an uncollectible account under the allowance method?A. Increases net incomeB. No effect on total assetsC. Decreases revenueD. Increases expenses needarrow_forwardWhat is the normal balance of Accounts Payable?A. DebitB. CreditC. ZeroD. Variespls coarrow_forwardWhat is the normal balance of Accounts Payable?A. DebitB. CreditC. ZeroD. Variescorrectarrow_forward
- What is the effect of writing off an uncollectible account under the allowance method?A. Increases net incomeB. No effect on total assetsC. Decreases revenueD. Increases expenses correctarrow_forwardNeed Help of this Financial Accountingarrow_forwardWhat is the effect of writing off an uncollectible account under the allowance method?A. Increases net incomeB. No effect on total assetsC. Decreases revenueD. Increases expensesneed helparrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license