Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.)
| 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 |
(a-1) Use MegaStat 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 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
