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...
-
Two projects have an identical net present value of $360,000. Are both projects equal in desirability?
-
A small publisher plans to spend $1000 for advertising a paperback book and estimates the printing cost is $2.50 per book. The publisher will receive $7 for each book sold. a. Find the function C =...
-
It is certainly legal for companies to read employees emails, and, because the employer is paying for the employees time and the computer and network equipment, I think its ethical. When employees...
-
Thrasher Construction Company was contracted to construct a building for $ 975,000. The building is owned by the customer throughout the contract period. The contract provides for progress payments....
-
Solve for August. Please Show Work. (Zoom in on your browser to see chart above) Process Costing - Assembly Department - JULY Information regarding inventory production for the Assembly Department...
-
Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following six-column table contains the company's unadjusted trial balance...
-
Which of the following is a characteristic of financial accounting? * Emphasizes decisions affecting the future Mandatory for external reports Reports to those inside the organization None of the...
-
Turn this information into an excel sheets with the excel formulas being shown P13.2 (LO 1, 2) (Issuance and Redemption of Bonds) Venezuela Co. is building a new hockey arena at a cost of $2,500,000....
-
2. An engineering firm hires you to certify a heated concrete floor design, as shown in Fig 2. Hot water flows through pipes that are embedded in the concrete slab. The water temperature inside the...
-
Calculate gross and net sales for your company. You are working in fashion design as an office assistant. The designer wants to know how the sale of the product has performed financially in the first...
-
71 Question 17 (4 points) You have a good business model in Canada. In Kitchener, you prepare prepackaged frozen healthy meals and sell these to households via your own webpage shop. Most of your...
-
Two years ago, Dave started a newly incorporated business with a strict policy of paying half the current annual profits to shareholders as dividends on Dec 3 1 % . if he generated a loss of 5 2 , 2...
-
C Not secure apter 10 Setting Standards, Materials and Labor Variances Tom Benoed and Tony Sorrentino own a small business devoted te kitchen and bath granite Inotallations. Recently, building...
-
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, =...
-
You copy an album cover online from your favorite CD and post it to your Facebook page. Infringement or not? (pp. 258259)
-
You find several very cool graphics online from an artist who has been dead for 15 years. You copy the graphics to post on your online business Website. Infringement or not? (pp. 258259)
-
You have added a short audio introduction to your Website that includes the beginning of Beethovens 5th symphony. Infringement or not? (pp. 258259)
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App