Hello,

Chrome File Edit View History Bookmarks People Tab Window Help 5 7 ) Wed 8:13 PM Q . When You Feel Like Giving Up eCampus: Home Content Wk 6 - Practice: Wk 6 Exercise x A newconnect.mheducation.com/flow/connect.html Apps Morgan State Uni. Wk 6 - Practice: Wk 6 Exercises [due Sat] i Saved Help Save & Exit Submit Check my work 11 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2005 2 2006 points 2007 2008 2009 2010 Book mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) References 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=]+ +2+]Q2+ (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 03 04 Mc Hill Education MAY 27 47 60X MEG X WExcel File Edit View Insert Format Tools Data Window Help . . . THE 5 5 . 5 Sun 2:20 AM Q = 2 W6 Item 11 CocaCola Revenues - Saved to my Mac Q @ Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Share Comments my cut Arial AA Copy 2b Wrap Text v General Normal Bad Good Neutral Calculation AutoSum . Paste Format BIUVV LAV EEE EE Merge & Center v $ ~ % 9 68 -28 Conditional Format Formatting as Table Check Cell Explanatory T.. Input Linked Cell Note Insert Delete Format Fill X Clear Filter Select Ideas Sensitivity Create and Share Adobe PDF Q12 H Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars) AA AB AC AD AE AF AG AH Al AK AM AN AO AP AQ AS AT AV Year Quarter Revenue 2005 Qtr1 5,194 Qtr2 6,298 Quarter 2005 In row-column format Qtr3 6,025 Qtr1 5,1945 2008 2009 2010 Qtr4 5,106 6,060 7,350 Qtr1 5,539 5,106 Qtr2 Qtr3 6,298 6,450 10 7,690 9,030 7,120 7,504 8,208 2006 8,653 Qtr2 Qtr3 Qtr4 6,025 6,398 7,647 8,296 8,010 8,405 6,450 6.398 5,539 5,890 7,288 7,010 7,462 10,473 Qtr4 5,890 2007 6,060 Qtr2 7,690 Qtr3 Qtr4 7,647 2008 Qtr1 7,288 7,350 Qtr3 9,030 8,296 Qtr4 7,010 2009 Qtr1 7,120 Qtr2 8,208 Qtr4 8,010 7,462 2010 Qtr1 Qtr2 7,504 8.653 Qtr3 8,405 Qtr4 10,473 Source: Standard & Poor's Stock Reports, http://finance.yahoo.com., and http://www.mergentonline.com Data Extra Sheet 100% MAY 31 X W P