problem 08-23 Algo (Using Regression Analysis forForecasting

Quarter:1,2,3,4

year 1: 2,0,5,5

year 2: 5,2,8,8

year 3: 7,6,10,10

Use a multiple regression modelwith dummy variables as follows to develop an equation to accountfor seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter3, 0 otherwise.
	If required, round your answers tothree decimal places. For subtractive or negative numbers use aminus sign even if there is a + sign before the blank. (Example:-300) If the constant is \"1\" it must be entered in the box. Do notround intermediate calculation.
	ŷ=   +   Qtr1+   Qtr2+   Qtr3
(c)	Compute the quarterly forecasts fornext year based on the model you developed in part (b).
	If required, round your answers tothree decimal places. Do not round intermediate calculation.
	Year Quarter Ft 4 1 4 2 4 3 4 4
(d)	Use a multiple regression model todevelop an equation to account for trend and seasonal effects inthe data. Use the dummy variables you developed in part (b) tocapture seasonal effects and create a variable t such thatt = 1 for Quarter 1 in Year 1, t = 2 for Quarter2 in Year 1,… t = 12 for Quarter 4 in Year 3.
	If required, round your answers tothree decimal places. For subtractive or negative numbers use aminus sign even if there is a + sign before the blank. (Example:-300)
	ŷ=   +  Qtr1+  Qtr2 +  Qtr3+   t
(e)	Compute the quarterly forecasts fornext year based on the model you developed in part (d).
	Do not round your interimcomputations and round your final answer to three decimalplaces.
	Year Quarter Period Ft 4 1 13 4 2 14 4 3 15 4 4 16
(f)	Is the model you developed in part(b) or the model you developed in part (d) more effective?
	If required, round yourintermediate calculations and final answer to three decimalplaces.
	Model developed in part(b) Model developed in part(d) MSE

Can you please show me how to step up excel spreadsheetfor this problem. How to figure out the problems on thisquestion.