Question: (LO 1-6) Consider the 2013 rejected loan data from LendingClub titled DAA Chapter 1-2 Data. Browse the file in Excel to ensure there are no

(LO 1-6) Consider the 2013 rejected loan data from LendingClub titled “DAA Chapter 1-2 Data.” Browse the file in Excel to ensure there are no missing 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. There should be 669,993 observations.

a. Assign each valid debt-to-income ratio into three buckets (labeled DTI bucket) by classifying each debt-to-income ratio into high (>20.0 percent), medium (10.0–

20.0 percent), and low (<10.0 percent) buckets. Consider using nested if–then statements to complete this. Or sort the row and manually input.

b. Run a PivotTable analysis that shows the number of loans in each DTI bucket.

Which DTI bucket had the highest and lowest grouping for this rejected Loans dataset? Any interpretation of why these loans were rejected based on debt-toincome ratios?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The question is incomplete because the first part of the instruction for problem a regarding the lab... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Data Analytics Accounting Questions!

(LO 1-6) Consider the 2013 rejected loan data from LendingClub titled DAA Chapter 1-2 Data. Browse the file in Excel to ensure there are no missing data. Because our analysis requires risk scores,...

Conduct an internet search to find an organization that lists its mission and vision statement on its website. What do the mission and vision statements communicate? How might the organization use...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

[ The following information applies to the questions displayed below. ] For Problems 9 , 1 0 , and 1 1 , we will be cleaning a data file in preparation for subsequent analysis. The analysis performed...

Required information [ The following information applies to the questions displayed below ] For Problems 9 , 1 0 , and uarr, we will be cleaning a data file in preparation for subsequent analysis....

Required information Skip to question [ The following information applies to the questions displayed below. ] For Problems 9 , 1 0 , and 1 1 , we will be cleaning a data file in preparation for...

Consider the 2 0 1 3 rejected loan data from LendingClub titled DAA Chapter 1 - 2 Data . To prepare the dataset for analysis, let s scrub the risk score data. First, because our analysis requires...

Consider the 2 0 1 3 rejected loan data from LendingClub titled "DAA Chapter 1 - 2 Data." Similar to the analysis done in the chapter, let s scrub the employment length. Because our analysis requires...

Consider the 2013 declined loan data from LendingClub titled RejectStatsB2013 from the Connect website. Similar to the analysis done in the chapter, lets scrub the risk score data. First, because our...

Consider the 2013 declined loan data from LendingClub titled "RejectStatsB2013".Similar to the analysis done in the chapter, let's scrub the risk score data. First, because our analysis requires risk...

Candyland Ltd. is the main supplier of fruit candies to customers. The company currently makes 72,000,000 packs of candies annually which uses fruit nectar. Each candy uses 0.0003 kilogram of fruit...

Why are organizations moving toward the use of experiential approaches to learning? What conditions are required for success?

that when revenues are measured based on the amount earned, and expenses are measured based on the amount incurred, as shown in the income statement, net income for the period was $4,165. Compare the...

Evaluate each of the following. 8 2 4 2 (4 2) 3

Identify which ETL tasks would be considered Validating the data, and which would be considered Cleaning the data. ETL Task 1. Compare the number of records that were extracted to the number of...

Identify the order sequence in the ETL process as part of mastering the data (i.e., 1 is first; 5 is last). Steps of the ETL Process 1. Validate the data for completeness and integrity. 2. Sanitize...

Match the specific analysis need/characteristic to the appropriate Tableau Track software tool: Tableau Prep Builder Tableau Desktop Tableau Public Specific Analysis Need/Characteristic 1. Advanced...