steps needed for 55.9. Thank you

Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No H21 + XVfx K L X A B C D E G H MyEducator Tasks Summary Statistics i Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score Max Ratio Min Ratio 1 Entire Sample un Default vs. Non-Default Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score 55.9 Complete the credit rating Default Yes column of the table. Non-Default No a. In cell H21), use the VLOOKUP By Ratings FICO Score Rating Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score function to assign a credit rating 10 620 Fair based on the table B10:C13) for 11 670 Good Very Good the first client in the list. 12 740 13 800 Exceptional b. Use copy and paste to fill the credit 14 High vs. Low PMT to Income Ratio rating for the remaining clients. 15 Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score 16 c. Note: Your formula must use Ratio over 0.30 Yes 17 Ratio under 0.30 No absolute references that allow the 18 formula in H21) to be copied and 19 client Data 20 pasted to other cells in the "Credit Client ID Loan Amount Income Monthly PMT PMT/Income Ratio FICO Score Credit Rating Default High Ratio? 21 40,918 7,500 1,640.3. 0.22 627 No Rating" column. 22 40,036 6,863 1,604.99 0.23 844 No 23 36,340 4,457 1,456.82 0.33 772 No 24 10,491 3,424 420.57 0.12 709 No 1 8,429 6,461 337.91 0.05 656 No 26 25,459 5,221 1,020.62 0.20 812 No 55.10 ) Calculate the number of 14,929 3,859 598.48 0.16 696 No 31,423 2,166 1,259.70 0.58 721 No 55.11 ) Calculate the loan principal 31,806 5,779 1,275.06 0.19 770 No 10 5,193 1,878 208.18 0.11 774 No 55.12 ) Calculate the average income ~ 11 16,585 4,866 564.87 0.14 831 No 12 47,243 2,317 1,893.91 0.82 724 No 55.13 ) Determine if each payment 13 46,801 3,222 1,876.19 0.58 337 Yes 14 46,625 2,143 1,869.13 0.87 733 Yes 55.14 ) Determine the number of 35 15 26,594 6,926 1,066.12 0.15 712 No 36 16 13,557 1,827 543.48 0.30 657 Yes 55.15) Calculate the total principal 37 17 30,950 3,703 1,240.74 0.34 803 No 38 18 30,015 2,151 1,203.26 0.56 710 Yes 55.16 Calculate the average loan Loans +