(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...
-
If an injured worker thinks the compensation for the injuries sustained is unfair, what course of action may be pursued to attempt to correct the problem?
-
What are the types of passive solar water heating systems and how do they function?
-
Dearborn Manufacturing Co. completed the following transactions during 2009 . Requirement Record the transactions in Dearborn's general journal. Jan. 16 Declared a cash dividend on the 4%, $100 par...
-
A 2000-liter water tank can withstand pressures up to 20.0bar absolute before rupturing. At a particular time the tank contains 165.0 kg of liquid water, the fill and exit valves are closed, and the...
-
The following data are taken from the accounting records of Gregory Manufacturing Company: Particulars This Year Last Year Ending inventories: Materials $ 90,000 $70,000 Work in Process $62,000...
-
1. All players but the retailer should answer this question. What do you think the retailers customer demand pattern looked like? How did your customer orders vary throughout the game? 2. What...
-
Given U(x,y)= min(x, 4y). Solve for the utility-maximizing combination of x and y. (Given that budget constraint: PX + PY = 1)
-
Why is creating a WBS an important aspect of project planning?
-
Explain how a system can learn by building decision trees, using the ID3 algorithm.
-
What are the key elements of a project scope document?
-
Describe briefly the process from project needs assessment to project planning.
-
Why might it be particularly difficult to program a computer to successfully play card games like bridge or poker? What sort of algorithms might you use to play these games?
-
Given the functions: = fx x 3 8 x = gx 2 x = hx 7 x 9 Evaluate the function g fx for = x 3 . Write your answer in exact simplified form. Select "Undefined" if applicable. g f 3 is
-
Determine the annual percentage yield for a loan that charges a monthly interest rate of 1.5% and compounds the interest monthly.
-
(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...
-
Write down the structure of a three-dimensional VARMA model if the vector time series has the following three components: \(\operatorname{SCM}(0,0), \operatorname{SCM}(0,1)\), and...
-
Consider the three SCMs of Question 3. If the maximum elements, in absolute value, of the three rows of the transformation matrix \(T\) are \((1,1),(2,3)\), and \((3,2)\), respectively. Write down...
-
Consider the realized volatilities of the Alcoa stock from January 2, 2003, to May 7, 2004, for 340 observations. The realized volatilities are the sum of squares of intraday \(m\)-minute log...
Study smarter with the SolutionInn App