Steps needed for 55.10. 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 D10 + XVfx B C D E F G H K A L MyEducator Tasks X Summary Statistics 1 Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score Max Ratio Min Ratio 55.10) Calculate the number of Entire Sample Default vs. Non-Default Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score clients by credit rating. Default Yes a. In cell D10), use the COUNTIF Non-Default No function to find how many clients By Ratings FICO Score Rating Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score have a Fair credit rating in this data LD 10 620 Fair set. 11 670 Good b. Reference the cells in the "Credit 12 740 Very Good 13 800 Exceptional Rating" column of the Client Data 14 High vs. Low PMT to Income Ratio table to calculate it. 15 our Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score c. Use copy and paste to fill the Count 16 Ratio over 0.30 Yes 17 Ratio under 0.30 No for the remaining ratings. 18 d. Note: Your formula must use 19 Client Data absolute references that allow the 20 Client ID Loan Amount Income Monthly PMT PMT/Income Ratio FICO Score Credit Rating Default? High Ratio? 21 10,918 7,500 1,640.35 0.22 127 No formula in D10) to be copied and 22 40,036 6,863 1,604.99 0.23 844 No pasted to another cell in the 23 36,340 4,457 1,456.82 0.33 772 No "Count" column. 24 10,491 3,424 420.57 0.12 709 No VOUAWN 8,429 6,461 337.91 0.05 556 No 26 25,459 5,221 1,020.62 0.20 312 No 1 14,929 3,859 598.48 0.16 596 No 8 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 664.87 0.14 331 No 12 17,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 557 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 +