Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars)

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

8,267

8,674

2006

Qtr1

5,226

Qtr3

6,037

6,454

7,690

8,393

8,044

8,426

Qtr2

6,476

Qtr4

5,551

5,932

7,331

7,126

7,510

10,494

Qtr3

6,454

Qtr4

5,932

2007

Qtr1

6,103

Qtr2

7,733

Qtr3

7,690

Qtr4

7,331

2008

Qtr1

7,379

Qtr2

9,046

Qtr3

8,393

Qtr4

7,126

2009

Qtr1

7,169

Qtr2

8,267

Qtr3

8,044

Qtr4

7,510

2010

Qtr1

7,525

Qtr2

8,674

Qtr3

8,426

Qtr4

10,494

Coca-Cola Revenues ($ mil1lions), 2005-2010 Quarter Qtrl Qtr2 Qtr3 Qtr4 2010 7,525 8,674 8,426 7,510 18,494 2005 2006 2007 2008 2009 5, 206 6, 310 6,037 5,551 5,226 6,476 6,454 5,932 6,103 7,733 7,690 7,331 7,379 9,846 8, 393 7,126 7,169 8,267 8, 844 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.) 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimel places.) 01 02 03 (a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.)