Coca-Cola Revenues ($ millions), 2005–2010
Quarter	2005	2006	2007	2008	2009	2010
Qtr1	5,196	5,109	6,065	7,360	7,130	7,700
Qtr2	6,300	6,455	7,695	9,035	8,212	8,655
Qtr3	6,027	6,402	7,652	8,299	8,015	8,407
Qtr4	5,541	5,895	7,293	7,015	7,468	10,475

(a-1) Use Mega Stat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.)

	1	2	3	4
2005
2006
2007
2008
2009
2010
mean

(a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.)

Q1	Q2	Q3	Q4

(a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.)

y_t = ___ x_t + ___

(b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.)

y_t = ____+ ___t + ___Q1 + ___Q2 + ___Q3

(c) Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.)

Quarter	Predicted
Q1
Q2
Q3
Q4