Question: Analysis one : Complete problems 5, 6 and 7 from chapter 1 with the following modifications to the problem instructions Problem 5 Create the six

  1. Analysis one: Complete problems 5, 6 and 7 from chapter 1 with the following modifications to the problem instructions
    1. Problem 5
      1. Create the six risk score buckets using the classifications from exhibit 1-10. Scores greater than 800 are Excellent.
      2. Do not do the pivot table analysis at this time
    2. Problem 6
      1. During data scrubbing, do not delete debt-to-income values of zero at this time
      2. Do not do the pivot table analysis at this time
    3. Problem 7
      1. Do part a.
      2. Part b and c were been done in problem 5 & 6
    4. Your table should have 691,814 records
    5. Create the following pivot tables(place them in one sheet)
      1. Number of rejected loans in each risk bucket and percentage breakdown
      2. Number of rejected loans in each DTI bucket and percentage breakdown
      3. Number of rejected loans based on employment length and percentage breakdown

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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 Accounting Questions!

Q:

OPERATIONS MANAGEMENT ASSIGNMENT 6 1 Human resources, project management and operations management are all equally vital to a business's success. Each of these focuses on different areas of the...

Q:

Working on the City of Smithville Short version. I need the journal entries for Chapters 5, 6, and 9 (including Budgetary) ASAP. Thank you for your help. Instructions City of Smithville Short Version...

Q:

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Q:

What factors should be considered in deciding whether the cost of capital for a foreign affiliateshould be higher, lower, or the same as the cost of capital for a comparable domestic operation?...

Q:

\f \f11TH EDITION STRATEGIC MANAGEMENT THEORY 11TH EDITION Strategic Management THEORY Charles W. L. Hill University of Washington - Foster School of Business Gareth R. Jones Melissa A. Schilling New...

Q:

Your manager has provided you the following matrix and asked that you use it to complete the design assessment phase of your testing. The manager has already performed a preliminary survey, and has...

Q:

PSYC 354 HOMEWORK 3 Central Tendency and Variability When submitting this file, be sure the filename includes your full name, course and section. Example: HW3_JohnDoe_354B01 Be sure you have reviewed...

Q:

PSYC 354 HOMEWORK 6 Percentiles and Hypothesis Testing with Z-Tests When submitting this file, be sure the filename includes your full name, course and section. Example: HW6_JohnDoe_354B01 Be sure...

Q:

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Q:

SA-TIED YOUNG SCHOLARS PROGRAMME Young Scholars This paper was produced as a part of the SA-TIED Young Scholars' programme. The programme is a part of SATIED's capacity building initiatives, designed...

Q:

Using net present value and payback period to evaluate investment opportunities Bruce Graham saved $250,000 during the 25 years that he worked for a major corporation. Now he has retired at the age...

Q:

The following accounts and balances were drawn from the records of Shearer Company at December 31, 2016: Cash .................. $22,100 Land .................. 43,000 Insurance expense ................

Q:

Identify a growth industry, a mature industry, and a declining industry. For each industry, identify the following: (a) the number and size distribution of companies; (b) the nature of barriers to...

Q:

Calculate the minimum and maximum takt time for the given

Q:

Consider a country where you may want to work. Research the cultural differences you may encounter and work out how this would affect the management of people in organisations in that country.

Q:

If you have fellow students from a number of countries, choose fi ve of them and discuss with them their working experience of how recruitment, performance management and reward operate in practice.

Q:

Disparate impact analysis (the four-fifths rule, standard deviation analysis) is used in employment discrimination cases. The National Assessment of Education Progress conducted by the U.S....