***Please use Excel***

The data given below is the quarterly exports for a company. Use Excel to answer the following questions based on the data:

1. Make a time plot of the data. What are your observations of the data based on the time plot?
2. Use the classical multiplicative decomposition model we went over in class to estimate the trend (use 4-MA), the seasonal indices, and then the forecast for the seventh year.

Year	Quarter	Sales (000)
1	1	480
	2	520
	3	300
	4	280
2	1	520
	2	540
	3	330
	4	280
3	1	540
	2	560
	3	330
	4	300
4	1	544
	2	582
	3	340
	4	310
5	1	628
	2	707
	3	370
	4	350
6	1	627
	2	725
	3	350
	4	340