(a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 declmal...
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 declmal places.) 2005 2006 2007 2008 2009 2010 mean (0-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) 01 02 03 (0-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) Coca-Cola Revenues ($ millions), 2905-2010 2006 5,121 6,470 6,414 5,910 2005 5, 202 6, 306 6,033 5,547 2007 6,880 7,710 7,667 7, 308 2008 2009 2010 Quarter Qtrl Qtr2 Qtr3 Qtr4 7,390 9,850 8, 308 7,860 7,160 8,224 8,830 7,486 7,512 8,661 8,413 18,481 (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.) Q1 + Q2 + Q3 quarter in 2011. (Enter your answers In millons rounded to 3 decimal (c) Use places.) regression equation to make a for Quarter Predicted Q1 Q2 Q3 04 Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars) Year Quarter Revenue 2005 Qtr1 In row-column format 5,202 6,306 6,033 5,547 5,121 6,470 6,414 5,910 Qtr2 Quarter 2005 2006 2007 2008 2009 2010 7,160 8,224 8,030 7,486 7,512 8,661 8,413 10,481 Qtr3 Qtr4 Qtr1 5,202 5,121 6,470 6,414 5,910 6,080 7,390 9,050 8,308 7,060 Qtr2 6,306 6,033 5,547 7,710 7,667 7,308 2006 Qtr1 Qtr3 Qtr2 Qtr4 Qtr3 Qtr4 6,080 7,710 7,667 7,308 7,390 9,050 8,308 7,060 2007 Qtr1 Qtr2 Qtr3 Qtr4 2008 Qtr1 Qtr2 Qtr3 Qtr4 2009 Qtr1 7,160 Qtr2 8,224 Qtr3 8,030 Qtr4 7,486 2010 Qtr1 7,512 Qtr2 8,661 Qtr3 8,413 Qtr4 10,481 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 declmal places.) 2005 2006 2007 2008 2009 2010 mean (0-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) 01 02 03 (0-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) Coca-Cola Revenues ($ millions), 2905-2010 2006 5,121 6,470 6,414 5,910 2005 5, 202 6, 306 6,033 5,547 2007 6,880 7,710 7,667 7, 308 2008 2009 2010 Quarter Qtrl Qtr2 Qtr3 Qtr4 7,390 9,850 8, 308 7,860 7,160 8,224 8,830 7,486 7,512 8,661 8,413 18,481 (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.) Q1 + Q2 + Q3 quarter in 2011. (Enter your answers In millons rounded to 3 decimal (c) Use places.) regression equation to make a for Quarter Predicted Q1 Q2 Q3 04 Quarterly Revenue for Coca Cola Company, 2005-2010 (millions of dollars) Year Quarter Revenue 2005 Qtr1 In row-column format 5,202 6,306 6,033 5,547 5,121 6,470 6,414 5,910 Qtr2 Quarter 2005 2006 2007 2008 2009 2010 7,160 8,224 8,030 7,486 7,512 8,661 8,413 10,481 Qtr3 Qtr4 Qtr1 5,202 5,121 6,470 6,414 5,910 6,080 7,390 9,050 8,308 7,060 Qtr2 6,306 6,033 5,547 7,710 7,667 7,308 2006 Qtr1 Qtr3 Qtr2 Qtr4 Qtr3 Qtr4 6,080 7,710 7,667 7,308 7,390 9,050 8,308 7,060 2007 Qtr1 Qtr2 Qtr3 Qtr4 2008 Qtr1 Qtr2 Qtr3 Qtr4 2009 Qtr1 7,160 Qtr2 8,224 Qtr3 8,030 Qtr4 7,486 2010 Qtr1 7,512 Qtr2 8,661 Qtr3 8,413 Qtr4 10,481
Expert Answer:
Answer rating: 100% (QA)
a1 from Megastat Timeseries Deseasonalization 1 2 3 4 2005 1047 0961 2006 0877 1... View the full 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 mathematics 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....
-
Determine the regression equation Negative amounts should be indicated by a minus sign Round your answers to 3 decimal places X Y Picture Picture Picture 2 Picture 2 Picture Picture 5 13 2375 5641 3...
-
The programming language is Java and all of the Classes I was given are in bold. ALIEN CLASS import imagePackage.RasterImage; import java.awt.BasicStroke; import java.awt.Color; import...
-
Consider the special case of model 2 where (1) any > /s is feasible and (2) both f () and the waiting-cost function are linear functions, so that E(TC) = Crs + CwL,
-
Find the area and perimeter of the rectangle in terms of the width W. The width Wis half the length.
-
P Ltd bought 50,000 of the 80,000 issued ordinary \( 1\) shares of S Ltd for \( 158,000\) on 31 August 19X8. S Ltd accounts are drawn up annually to 31 December. The balance sheet of S Ltd on 31...
-
Kenseth Corp. has the following beginning-of-the-year present values for its projected benefit obligation and market-related values for its pension plan assets. The average remaining service life per...
-
Suppose you can invest in fund R&R (named after Risk and Return), which manages a portfolio with an expected return of 15% and a standard deviation of 20%. At the same time, the T-bill rate is 8%....
-
Rico is excited about the revenues that Orion generated during its first year of business. The main revenue source is a matchmaking service for clients seeking a romantic relationship. New clients...
-
Question 2: The paper flow to be expected through one section of city hall consists of the following: o 10 medical records per day from records to marriage licenses o 7 certificates per day from...
-
Find the 70th percentile. A customer service representative must spend different amounts of time with each customer to resolve various concerns. The amount of time spent with each customer can be...
-
Miller Retailing, Inc., maintains a staff of three full-time internal auditors who report directly to the controller. In planning to use the internal auditors to help in performing the audit, the...
-
Discuss the format of a report on condensed financial statements. What type of assurance is provided?
-
Define a special report according to AU Section 623.
-
Regardless of the assessed level of control risk, an auditor would perform some a. Tests of controls to determine the effectiveness of internal controls. b. Analytical procedures to verify the design...
-
Which statement is least indicates the benefit of leverage ratio O a. The ability to borrow money O b. Credit risk O c. Solvency d. Suppliers overlook Clear my choice
-
Periwinkle Company is a multinational organization. Its Parts Division is located in Lavender Land, while its Assembly Division is located in North Orchid. During the current year Periwinkle Companys...
-
(a) Based on the R2 and ANOVA table for your model, how would you assess the t? (b) Interpret the p-value for the F statistic. (c) Would you say that your model's t is good enough to be of practical...
-
Define three quality metrics that might be used to describe quality and performance in the following consumer products: (a) Your personal vehicle (e.g., car, SUV, truck, bicycle, motorcycle); (b) The...
-
Rates of return (annualized) in two investment portfolios are compared over the last 12 quarters. They are considered similar in safety, but portfolio B is advertised as being "less volatile." (a) At...
-
210 Use divisibility rules to determine if each of the following is divisible by 3.
-
130 Use divisibility rules to determine if each of the following is divisible by 5 .
-
237 Use divisibility rules to determine if each of the following is divisible by 5 .
Study smarter with the SolutionInn App