10 Coca-cola Revenues ($ millions ), 2095-2010 Quarter 2005 2096 2087 2098 2009 2010 Qtr1 5,206 5,226 6,103 7, 379 7,169 7,525 Qtr2 6,476 7,733 9, 046 8,267 B, 674 2 6,310 Otr3 6,037 6,454 7,690 8, 393 8, 044 B, 426 points. otra 5.551 5.932 7,331 7, 126 7,519 10,494 Skipped 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.) eBook 2095 2206 References 2907 2008 2009 2010 mean (a-2) State the adjusted four quarterly Indexes. (Round your answers to 3 decimal places.) 01 02 (a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) (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.) 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 Q2 Q3 04