******Break down the question by each letter.*******

Consider the following data. Quarter Year 1 Year 2 Year 3 1 4 6 2 2 3 3 3 5 4 5 7 7 6 6 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 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 developed in part (1) above. 3. Use a multiple regression model to develop an equation to account for trend and seasonal effects. Create a variable t such that t=1 for Qtr 1 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 effective? Justify your