i asked this question previously and got the wrong answers. Everything after the 2008 row was wrong.   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       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

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter4: Polynomial And Rational Functions
Section4.6: Rational Functions
Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.
icon
Related questions
Topic Video
Question
80%

i asked this question previously and got the wrong answers. Everything after the 2008 row was wrong.

 

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  
 
  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                
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Algebra
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning