Steps needed for 55.16. Thank you.
Home Insert Draw Page Layout Formulas Data Review View 9 Tell me Share Comments Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? F16 * X V fx A B C D E F G H K L MyEducator Tasks X 1 Summary Statistics Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score Max Ratio Min Ratio 55.16 ) Calculate the average loan Entire Sample Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score values for the clients with high credit to Default vs. Non-Default Count Total Loan Default Yes income ratios. Non-Default No a. In cell F16), use the AVERAGEIF By Ratings FICO Score Rating Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score function to calculate the average 10 520 Fair income for those who have a high 11 570 Good payment to income ratio. 12 740 Very Good 13 300 Exceptional b. Reference cell C16) as criteria, and 14 High vs. Low PMT to Income Ratio "High Ratio?" and "Income" 15 Count Total Loan Average Income Average Monthly PMT Average PMT/Income Rati Average FICO Score columns of Client Data table in the 16 Ratio over 0.30 Yes AVERAGEIF function. 17 Ratio under 0.30 No 18 c. Use copy and paste to fill cells F17) 19 Client Data and G16:117). 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 527 No d. Note: Your formula must use 22 40,036 6,863 1,604.99 0.23 844 No absolute references that allow the 23 36,340 4,457 1,456.82 0.33 772 No formula in F16) to be copied and 10,491 3,424 420.57 0.12 709 No 8,429 6,461 337.91 0.05 656 No pasted to other cells in the 5 CO V G U A W N 25,459 5,221 1,020.62 0.20 812 No "Average Income," "Average 14,929 3,859 598.48 0.16 696 No 31,423 2,16 1,259.70 0.58 721 No Monthly PMT," "Average 31,806 6,779 1,275.06 0.19 770 No PMT/Income Ratio," and "Average 5,193 1,878 208.18 0.11 774 No 11 16,585 4,86 664.87 0.14 831 No FICO Score" columns. 12 47,243 2,317 1,893.91 0.82 724 No 13 46,801 3,222 1,876.19 0.58 837 Yes 1 14 46,625 2,143 1,869.13 0.87 733 Yes 15 26,594 6,926 1,066.12 0.15 712 No 36 16 13,557 1,827 543.48 0.30 657 Yes 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 Next > Loans +
