Coca-Cola Revenues ($ millions), 2005-2010Quarter200520062007200820092010Qtr15,1965,1096,0657,3607,1307,700Qtr26,3006,4557,6959,0358,2128,655Qtr36,0276,4027,6528,2998,0158,407Qtr45,5415,8957,2937,0157,46810,475

Click here for the Excel Data File

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

1234200520062007200820092010mean

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

Q1Q2Q3Q4

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

QuarterPredictedQ1Q2Q3Q4