Steps needed for 55.12. 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 F10 X V fx | A B C D E F G H K L MyEducator Tasks Summary Statistics W N Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score Max Ratio Min Ratio Entire Sample Default vs. Non-Default Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score 55.12 ) Calculate the average income Default Yes levels for each client by credit rating. Non-Default No a. In cell F10), use the AVERAGEIF By Ratings FICO Score Ratin Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score function to calculate the average 10 620 Fair income for those who have a Fair 570 Good credit rating. 740 Very Good 13 300 Exceptional b. Reference the cells in the "Credit 14 High vs. Low PMT to Income Ratio Rating" and "Income" columns of 15 Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score the Client Data table to calculate it. 16 Ratio over 0.30 Yes 17 Ratio under 0.30 No c. Use copy and paste to fill the 18 Average Income for clients with 19 Client Data other ratings as well as the rest of 20 Client ID Loan Amount Income Monthly PMT PMT/Income Ratio FICO Score Credit Rating Default? High Ratio? 21 40,918 7,500 1,640.35 0.22 $27 the table (Average Monthly PMT, 22 40,036 6,863 1,604.99 0.23 844 No Average PMT/Income Ratio, and 23 36,340 4,457 1,456.82 0.33 772 No Average FICO Score for all different 24 10,491 3,424 420.57 0.12 709 No 8,429 6,461 337.91 0.05 656 No credit ratings). 25,459 5,221 1,020.62 0.20 812 No d. Note: Your formula must use 14,929 3,859 598.48 0.16 696 No absolute references that allow the 31,423 2,166 1,259.70 0.58 721 No 31,806 6,779 1,275.06 0.19 770 No formula in F10) to be copied and 10 5,193 1,878 208.18 0.11 774 No pasted to other cells in the 11 16,585 4,866 564.87 0.14 831 No 12 47,243 2,317 1,893.91 0.82 724 No "Average Income," "Average 13 46,801 3,222 1,876.19 0.58 837 Yes Monthly PMT," "Average 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 PMT/Income Ratio," and "Average 36 16 13,557 1,827 543.48 0.30 657 Yes FICO Score" columns. 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 1 Loans +