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