Coca-Cola Revenues ($ millions), 20052010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,196 5,109 6,065 7,360
Fantastic news! We've Found the answer you've been seeking!
Question:
| 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.)
yt = ___ xt + ___
(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.)
yt = ____+ ___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 | |
Expert Answer:
a Centered Moving Ratio to Seasonal 2005 t Year Quarter 2005 Average CMA Indexes Deseasonalized 1 1 ... View the full answer
Related Book For 
Posted Date:
