Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090...

Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010

Qtr1 5,206 5,131 6,090 7,410 7,180 7,516

Qtr2 6,310 6,480 7,720 9,060 8,232 8,665

Qtr3 6,037 6,422 7,677 8,314 8,040 8,417

Qtr4 5,551 5,920 7,318 7,100 7,498 10,485

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

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

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075...

Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075 7,380 7,150 7,800 Qtr2 6,304 6,465 7,705 9,045 8,220 8,659 Qtr3 6,031 6,410 7,662 8,305 8,025 8,411 Qtr4 5,545 5,905 7,303 7,040 7,480 10,479 (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...

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 ...

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 7,350 8,332 8,263 9,368 Qtr2 7,697 8,599 9,607 10,945 10,592 14,801 Qtr3 8,184 8,950 10,171 11,244 11,080 15,514 Qtr4 10,096 10,383 12,346 12,729 13,297 18,155 (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 =___...

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 ...

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 7,350 8,333 8,263 9,368 Qtr2 7,697 8,599 9,607 10,945 10,592 14,801 Qtr3 8,184 8,950 10,171 11,244 11,080 15,514 Qtr4 10,096 10,383 12,346 12,729 13,297 18,155 (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 =___...

India's Current Account Assumptions (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...

India's Current Account Assumptions (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Goods: exports 77,939 102,175 123,876 153,530 199,065 167,958 230,967 307,847 298,321 319,110 329,633 Goods: imports -95,539 -134,692 -166,572 -208,611 -291,740 -247,908 -324,320 -428,021 -450,249 -433,760 -415,529 Balance on goods -17,600 -32,517 -42,696 -55,081 -92,675 -79,950 -93,353 -120,174 -151,928 -114,650 -85,895 Services: credit 38,281 52,527 69,440 86,552 106,054 92,889 117,068 138,528 145,525 148,649 156,252 Services: debit -35,641 -47,287 -58,514 -70,175 -87,739 -80,349 -114,739 -125,041...

Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $ 7.46 $ 7.91...

Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $ 7.46 $ 7.91 $ 8.38 $ 8.80 $ 9.24 $ 9.70 $ 10.28 $ 10.79 $ 11.33 $ 12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January 1, 2011 price of the stock is $110.00, determine the current required rate of return for the company (use the geometric growth rate to calculate the...

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...

Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...

This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...

This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009 59994 2010 61515 2011 63182 2012 67989 2013 70448 2014 72601 2015 75482 2016 78341 2017 81111 2018 82517 2019 83275 2020 84005 I. (a) Determine the trend line using both linear and two nonlinear equations Hint: You can choose any two of the nonlinear options in edit trend lines within Tableau. (b) Write down the equations (coefficients). Hint: Double click on trend line...

Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES:...

Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES: Equity share capital 400,000 600,000 500,000 400,000 600,000 Long term loan 500,000 250,000 300,000 400,000 300,000 Sundry creditors 200,000 300,000 350,000 340,000 250,000 Short term loan 50,000 40,000 60,000 115,000 50,000 ASSETS: Land and Building 300,000 500,000 600,000 700,000 450,000 Furniture 600,000 450,000 400,000 400,000 500,000 Cash at bank 50,000 60,000 70,000 50,000 70,000 Stock 140,000 150,000 100,000 80,000 120,000 Prepaid expenses 60,000 30,000...

THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Year Ended December 31, 2008 2007 2006...

THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME Year Ended December 31, 2008 2007 2006 (In millions except per share data) NET OPERATING REVENUES $31,944 $ 28,857 $ 24088 Cost of goods sold 11,374 10,406 8,164 GROSS PROFIT 20,570 18,451 15,924 Selling, general and administrative expenses 11,774 10,945 9,431 Other operating charges 350 254 185 OPERATING INCOME 8,446 7,252 6,308 Interest income 333 236 193 Interest expense 438 456 220 Equity income (loss) — net (874) 668 102 Other...

Year Quarter Revenue 2005 Qtr1 5,200 Qtr2 6,296 Qtr3 6,023 Qtr4 5,537 2006 Qtr1 5,103 Qtr2...

Year Quarter Revenue 2005 Qtr1 5,200 Qtr2 6,296 Qtr3 6,023 Qtr4 5,537 2006 Qtr1 5,103 Qtr2 6,445 Qtr3 6,394 Qtr4 5,885 2007 Qtr1 6,055 Qtr2 7,685 Qtr3 7,642 Qtr4 7,283 2008 Qtr1 7,340 Qtr2 9,025 Qtr3 8,293 Qtr4 7,005 2009 Qtr1 7,110 Qtr2 8,204 Qtr3 8,005 Qtr4 7,456 2010 Qtr1 7,600 Qtr2 8,651 Qtr3 8,403 Qtr4 10,471 (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...

Subjects