Economics Homework Help

Year	Qtr	Period, t	Visitors, Yt
2016	Q1	1	210
	Q2	2	260
	Q3	3	480
	Q4	4	250
2017	Q1	5	215
	Q2	6	275
	Q3	7	490
	Q4	8	255
2018	Q1	9	218
	Q2	10	282
	Q3	11	505
	Q4	12	265
2019	Q1	13	220
	Q2	14	290
	Q3	15	525
	Q4	16	270

The above Table shows the number of visitors per quarter recorded at one of the tourist parks in the United States. Using the Excel and multiplicative technique to decompose seasonal data:

a) Calculate the 4-year moving average

b) Calculate the centered moving average (CMA)

c) Isolate seasonal factors or indexes; and, where necessary, normalize (scale) the factors

d) Using the factors above, deseasonalize the original time series data

e) Run the regression analysis for deseasonalized data and Period t. Take Period t as independent variable and deseasonalized time series data as dependent variable

f) From the output generated in e) above, write the regression equation