Year Quarter Revenue 2005 Qtr1 5,206 In row-column format Qtr2 6,310 Quarter 2005 2006 2007 2008 2009 2010 Qtr3 6,037 Qtr1 5,206 5,226 6,103 7,379 7,169 7,525 Qtr4 5,551 Qtr2 6,310 6,476 7,733 9,046...

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

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

(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.)