Question
Coca-Cola Revenues ($ millions), 2005-2010 Quarter 200520062007200820092010Qtr15,2065,2266,1037,3797,1697,525Qtr26,3106,4767,7339,0468,2678,674Qtr36,0376,4547,6908,3938,0448,426Qtr45,5515,9327,3317,1267,51010,494 Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round
Coca-Cola Revenues ($ millions), 2005-2010Quarter200520062007200820092010Qtr15,2065,2266,1037,3797,1697,525Qtr26,3106,4767,7339,0468,2678,674Qtr36,0376,4547,6908,3938,0448,426Qtr45,5515,9327,3317,1267,51010,494
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.)
1234200520062007200820092010mean
(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 +-------
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started