Question: 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

PLEASE ANSWER IN EXCEL

PLEASE ANSWER IN EXCEL Consider the following

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!