a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 1 3 2005 1.045 0.957 2006 0.890 1.084 1.053 0.927 2007 0.910 1.099 1.043 0.952 2008 0.928 1.129 1.054 0.909 2009 2010 1.032 mean Coca-Cola Revenues ($ millions), 2005-2010 Quarter Qtr1 Qtr2 Qtr3 Qtr4 2005 2006 2007 2008 2009 2010 5,206 5,226 6,103 7,379 7,169 7,525 6,310 6,476 7,733 9,046 8,267 6,037 6,454 7,690 8,393 8,044 5,551 5,932 7,331 7,126 7,510 10,494 8,674 8,426 Click here for the Excel Data File (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= 154.07 Xt+ 5334.2 (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= 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 a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 1 3 2005 1.045 0.957 2006 0.890 1.084 1.053 0.927 2007 0.910 1.099 1.043 0.952 2008 0.928 1.129 1.054 0.909 2009 2010 1.032 mean Coca-Cola Revenues ($ millions), 2005-2010 Quarter Qtr1 Qtr2 Qtr3 Qtr4 2005 2006 2007 2008 2009 2010 5,206 5,226 6,103 7,379 7,169 7,525 6,310 6,476 7,733 9,046 8,267 6,037 6,454 7,690 8,393 8,044 5,551 5,932 7,331 7,126 7,510 10,494 8,674 8,426 Click here for the Excel Data File (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= 154.07 Xt+ 5334.2 (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= 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
Expert Answer:
Related Book For
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these economics questions
-
Use MegaStat or MINITAB to generate 95 percent confidence and prediction intervals for various X-values.
-
(a) Use MegaStat or MINITAB to deseasonalize the monthly Corvette sales data and t a trend. Interpret the results. (b) Use MegaStat or MINITAB to perform a regression using seasonal binaries....
-
(a) Use MegaStat or MINITAB to deseasonalize the quarterly data on Coca-Cola's revenues and t a trend. Interpret the results. (b) Use MegaStat or MINITAB to perform a regres- sion using seasonal...
-
You have recently been hired as a consultant for a personal financial planning firm. One of your first projects is creating a retirement plan for a couple, Tom and Helena Keeley. They have just...
-
Find an equation to fit each set of data. a. x y 1..................8 4.................17 6.................23 7.................26 b. x y 0.....................2 3...................54...
-
Does your campus have a career center? What services do they provide to students and graduates of your school?
-
Xavi decides to short sell 10,000 shares of Guiness Co. stock, currently trading at \($7.00\) per share. Determine Xavis profits if Guiness stock trades at \($5.00\) per share at the moment in which...
-
A travel and tour company has two tables relating to customers: Families and Countries. Each tour offers a discount if a minimum number of people book at the same time. Write a query (sql oracle)to...
-
direction and 0 Find magnitude, resultant for the system of forces 20 kN 25 kN location of of the 60 30 A B shown in figure. 3 m D 3 m C 45 18 kN 12 kN
-
Water at 15°C is drained from a large reservoir using two horizontal plastic pipes connected in series. The first pipe is 20 m long and has a 10-cm diameter, while the second pipe is 35 m long...
-
On 1/1/13 Karitas Inc., a calendar-year company is created with an equity investment of $720. On the same day, the company purchases 1 share of stock in another company for $360. The 1 share of stock...
-
The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 30 percent increase in sales next year, and...
-
A Darrieous rotor has an area of 1500 m 2 and operates at the optimal tip speed ratio. What is its power output in a wind with a velocity of 20 m/s?
-
Eaton Manufacturing currently produces 2,000 tables per month. The following per unit data for 2,000 tables apply for sales to regular customers: Direct materials Direct manufacturing labor Variable...
-
The following context-free grammar has an e-rule. SaXbY Za X Xa | Y |b Y YbY aZ | XX | E Z SS baa We want to build an equivalent CFG without any e-rule. in the language generated by this CFG, we...
-
The Bean Company provides fresh coffee beans for restaurants, hotels, and other food service companies. Bean offers three types of coffee beans: Premium, Gourmet, and Quality. Each of the three...
-
How do global forces such as globalization and transnationalism shape the nature and perception of deviance, particularly in terms of cross-cultural understandings and the spread of certain norms and...
-
Write the given system without the use of matrices. D) - ()- d (x sin t + 8 (2+ 1)
-
In a study of stock prices from 1970 to 1994, the correlation between Nasdaq closing prices on successive days (i.e., with a 1-day lag) was r = .13 with a t statistic of 5.47. Interpret this result.
-
Calculate each compound event probability: a. P (X 3), = 4.3 b. P (X > 7), = 5.2 c. P (X < 3), = 2.7
-
Calculate the test statistic and p-value for each sample. State the conclusion for the specified a. H0: = 200 versus H1: 200, = .025, x-bar = 203, s = 8, n = 16 b. H0: 200 versus H1: < 200, =...
-
A photographer focuses his camera on his subject. The subject then moves closer to the camera. To refocus, should the lens be moved closer to or farther from the detector? Explain.
-
A student makes a microscope using an objective lens and an eyepiece. If she moves the lenses closer together, does the microscope's magnification increase or decrease? Explain.
-
The object for a magnifier is usually placed very close to the focal point of the lens, creating a virtual image very far away where it can be viewed with the relaxed eye. But the object could be...
Study smarter with the SolutionInn App