Steps needed for 55.14. 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 D16 + XV fx A B C D E F G H K L MyEducator Tasks X Summary Statistics Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score Max Ratio Min Ratio 55.14 ) Determine the number of Entire Sample clients with a high payment to income Default vs. Non-Default Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score ratio. Default Yes Non-Default No a. In cell D16), use the COUNTIF By Ratings function to calculate the number of FICO Score Rating Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score people who have a high payment to 10 $20 Fair 11 570 Good income ratio. 12 740 Very Good b. Reference cell C16) as criteria and 13 800 Exceptional "High Ratio?" column of Client Data 14 High vs. Low PMT to Income Ratio 15 Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score table in the COUNTIF function. 16 Ratio over 0.30 Yes c. Use copy and paste to fill the 17 Ratio under 0.30 No "Count" of low ratio client in cell 18 19 Client Data D17). 20 Client ID Loan Amount Income Monthly PMT PMT/Income Ratio FICO Score Credit Rating Default? High Ratio? d. Note: Your formula must use 21 40,918 7,500 1,640.3 0.22 627 No absolute references that allow the 22 40,036 6,863 1,604.99 0.23 844 No 23 36,340 4,457 1,456.82 0.33 772 No formula in D16) to be copied and 24 10,491 3,424 420.57 0.12 709 No pasted to another cell in the 8,429 6,461 337.91 0.05 656 No 25,459 5,221 1,020.62 312 No "Count"" column. 0.20 14,929 3,859 598.48 0.16 696 No 31,423 2,166 1,259.70 0.58 721 No 1 9 31,806 6,779 1,275.06 0.19 770 No 10 5,193 1,878 208.18 0.11 774 No 11 16,585 4,866 664.87 0.14 331 No 55.15 ) Calculate the total principal 12 47,243 2,317 1,893.91 0.82 724 No Yes 55.16 ) Calculate the average loan 13 46.801 3,222 1,876.19 0.58 337 14 46.625 2,143 1,869.13 0.87 733 Yes 35 15 26,594 6,926 1,066.12 0.15 712 No 36 16 13,557 1,827 543.48 0.30 557 Yes 37 17 30,950 3,703 1,240.74 0.34 303 No Next > 38 18 30,015 2,151 1,203.26 0.56 710 Yes Loans +