Coca-Cola Revenues ($ millions), 20052010
Quarter	2005	2006	2007	2008	2009	2010
Qtr1	5,206	5,226	6,103	7,379	7,169	7,525
Qtr2	6,310	6,476	7,733	9,046	8,267	8,674
Qtr3	6,037	6,454	7,690	8,393	8,044	8,426
Qtr4	5,551	5,932	7,331	7,126	7,510	10,494

Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Colas 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