Data Analytics For Accounting
Data Analytics For Accounting
19th Edition
ISBN: 9781260375183
Author: RICHARDSON
Publisher: MCG
bartleby

Videos

Textbook Question
Book Icon
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.

  1. 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.
  2. 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.
  3. 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.
  4. 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?
  5. 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?
Blurred answer
Students have asked these similar questions
Could you explain the steps for solving this financial accounting question accurately?
I need help with this financial accounting question using standard accounting techniques.
RBI company issues $500,000 face value bonds with a 6% stated interest rate, payable semiannually. The bonds sell for $532,000 (at a premium) and have 10 years until maturity. Using the straight-line method, what is the amount of premium amortization for each semiannual interest payment?
Knowledge Booster
Background pattern image
Accounting
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.
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Text book image
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license