'Office Les mises jour do scurit, les correctits, les amid PROBLEM ONE. SO POINTS You have been hired by Salt Le Bank, a boutique lending Institution that targets young professionals moving to the Low Country. They have observed that when Interest rates decline, many of their clients turn to them for refinancing home mortgages. Salt Life Bank has turned to you to help them better plan their staffing needs in the mortgage department. They have provided you with the following data showing the average prime Interest rate and the total number of mortgage applications over a twenty-month period. This data has been made available in a workbook labeled Salfe Bank Interest Rate 0.0400 0.0430 Applications 3,098 2,785 2,515 0.0430 0.04TO 0.0470 0.0620 0,0560 0.0670 0.0810 0.0620 0.0820 0.0680 0.0710 0.0760 0.0830 0.0090 0.000 0.0050 0.0970 0.0980 Interest Rate Squared 0.0016 0.0018 0.0016 0.0032 0.0022 0.0027 0.0031 0.0032 0.0037 0.0036 0.0038 0.0016 0.0050 0.0058 0.0059 0.0079 0.0058 0.000 0.00 O DODG 1.873 1,794 1,450 1,177 822 896 740 740 722 540 375 425 360 389 339 336 What is the Real Issue"? Demonstrate at least three methods of modeling analysis and make a succinct recommendation to SLB. Which model would you recommend? Why? BONUS QUESTION: 10 POINTS Develop 95 prediction intervals for at least two of your models 811 mots EX Anglais (Etats-Unis) 'Office Les mises jour do scurit, les correctits, les amid PROBLEM ONE. SO POINTS You have been hired by Salt Le Bank, a boutique lending Institution that targets young professionals moving to the Low Country. They have observed that when Interest rates decline, many of their clients turn to them for refinancing home mortgages. Salt Life Bank has turned to you to help them better plan their staffing needs in the mortgage department. They have provided you with the following data showing the average prime Interest rate and the total number of mortgage applications over a twenty-month period. This data has been made available in a workbook labeled Salfe Bank Interest Rate 0.0400 0.0430 Applications 3,098 2,785 2,515 0.0430 0.04TO 0.0470 0.0620 0,0560 0.0670 0.0810 0.0620 0.0820 0.0680 0.0710 0.0760 0.0830 0.0090 0.000 0.0050 0.0970 0.0980 Interest Rate Squared 0.0016 0.0018 0.0016 0.0032 0.0022 0.0027 0.0031 0.0032 0.0037 0.0036 0.0038 0.0016 0.0050 0.0058 0.0059 0.0079 0.0058 0.000 0.00 O DODG 1.873 1,794 1,450 1,177 822 896 740 740 722 540 375 425 360 389 339 336 What is the Real Issue"? Demonstrate at least three methods of modeling analysis and make a succinct recommendation to SLB. Which model would you recommend? Why? BONUS QUESTION: 10 POINTS Develop 95 prediction intervals for at least two of your models 811 mots EX Anglais (Etats-Unis)