Need Assistance on this and how to calculate on excel

Chapter 1. Truist Bank started its operations in April 2020. Since then. they have collected monthly data regarding new accounts opened in the bank esters:r month until September 3321. The table below shows how the new accounts for each of those '18 months. WH.EEIEHHEIHEIIIEEEIEE I'IEW Based on this information. theyr would like to predict how marry new accounts theyI can expect to get in the month of October {the 19'\" month}. However. there is a disagreement among their managers on which of the foilowing methods is the most suitabie for making the predictions: . Regression Analysis [with no seasonality] . Moving Average {with m = 3} . Exponential smoothing [with alpha = (133:: Do a comparison analysis by nding the MSEs using all three methods and ll in the blanks below {round to two decimal places]: 1. The MSE obtained using the Regression Analysis model is: 2. The MSE obtained using the Moving Average method is: 3211.; 1 The MSE obtained using the Exponential Smoothing method is: 1459-7\" a. 1What should be the preferred method for forecasting here? : 5. The predicted value for Uctotn {1'5\"}l month] new accounts =