PLEASE ANSWER IN EXCEL

Consider the following data. Quarter Year 1 Year 2 1 4 Year 3 6 7 2 3 6 2 3 3 5 6 4 5 7 8 1. Use multiple regression model with dummy variables as follows to account for the seasonal effects in the data as follows Qtr 1=1 if Qtr 1, 0 otherwise Qtr 2=1 if Qtr 2,0 otherwise Qtr 4=1 if Qtr 4,0 otherwise Qtr 3=1 if Qtr 3, 0 otherwise Write down the regression equation obtained 2. Compute the quarterly forecasts for the next year based on the model you developedin part (1) above. 3. Use a multiple regression model to develop an equation to account for trend and seasonal effects and create a variablet such that t=1 for Qtr 1in year 1 and t=2 for Qtr 2 in year 1,...t=12 for Qtr 4 in year 3. 4. Compute the quaterly forecasts for the next year based on the model you developed in part (3). 5. Is the model you developed in part (2) or the one you developed in part (4) more efective? Justify your