ZuoTi.Pro
Question

DATA ANALYTICS

Item 9

Item 9 2 points

Coca-Cola Revenues ($ millions), 2005–2010
Quarter200520062007200820092010
Qtr15,2045,1266,0857,4007,1708,000
Qtr26,3086,4757,7159,0558,2288,663
Qtr36,0356,4187,6728,3118,0358,415
Qtr45,5495,9157,3137,0807,49210,483

 

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.)
 



1234
2005

2006
2007
2008
2009
2010

mean

 
(a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.)
 

Q1Q2Q3Q4

 
(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 +  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.)
 

QuarterPredicted
Q1
Q2
Q3
Q4


0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
DATA ANALYTICS
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2...

    Coca-Cola Revenues ($ millions), 2005-2010 Quarter 2005 2006 2007 2008 Qtri 5,196 5,109 6,065 7,360 Qtr2 6,300 6,455 7,695 9,035 Qtr3 6,027 6,402 7,652 8,299 Otr4 5,541 5,895 7,293 7,015 2009 2010 7,130 7,700 8,212 8,655 8,015 8,407 7,468 10,475 Click here for the Excel Data File (2-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2 3 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes....

  • 2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 ...

    2005 2006 2007 2008 2009 2010 6,5es 7,205 7.30 8,333 8.263 9,368 7,697 8,599 9,607 10,945 10.592 14.,801 Ctr3 8.184 8,950 10,171 11,244 11,080 15,514 Ctr4 10,096 10,383 12,346 2,729 13297 18,155 Click here for the Excel Data Fie (a-1) Use Megastat or MINTAB to deseasonalize Pepsico's quarterly data (Round your answers to 3 decimal places.) (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q3 04 (a-3) what is the trend model for the...

  • 1. We have obtained the following information about GDP in the U.S. economy from the Bureau...

    1. We have obtained the following information about GDP in the U.S. economy from the Bureau of [2 points) Year Quarter 2007 01 eeeee 2008 Real GDP (billions of chained 2012 $) $15,493.3 $15,582.1 $15,666.7 $15,762.0 $15,671.4 $15,752.3 $15,667.0 $15,328.0 $15,155.9 $15,134,1 $15,189.2 $15,356.1 $15,415.1 $15,557.3 $15,672.0 $15,750.6 Q1 @2 Q3 Q4 Q1 Q2 Q3 04 Q1 Q2 Q3 Q4 2009 2010 a. During which quarters was the U.S. economy in an expansion? During which quarters was the U.S. economy...

  • Figure 17.26 depicts the US aggregate demand between 2006 Q2 and 2010 Q4. Based on this...

    Figure 17.26 depicts the US aggregate demand between 2006 Q2 and 2010 Q4. Based on this information, which of the following statements is correct? Consumption Residential investment Non-residential investment Government consumption and investment Net exports Recession Contribution to real GDP growth (percentage points at annual rate) -1.8 Onset of the crisis: 2006 Q2-2007 Q4 Crisis: 2008 Q1-2009 Q2 Recovery 2009 Q3-2010 Q4 o In the recession, not only did households stop purchasing new houses and other consumption goods, but also...

  • A manager uses the following equation below to forecast quarterly demand for a product: Yt =6,000+...

    A manager uses the following equation below to forecast quarterly demand for a product: Yt =6,000+ 50 t, where t = 0 at Q2 of last year (2010). Quarter relatives are Q1 = .6, Q2 = .9, Q3= 1.1, and Q4=1.2. What forecasts are appropriate for the last quarter (Q4) of this year (2011)? 5,400 6,060 7,440 7,560 None of the above

  • Using the data in the table below, calculate the CPI and the inflation rate in each...

    Using the data in the table below, calculate the CPI and the inflation rate in each year using 2005 as the base year. Instructions: Round your answers to one decimal place.    Year Price of basket ($) CPI Inflation rate 2005 20,000 — 2006 21,500 2007 22,800 2008 26,150 2009 28,825 2010 32,700

  • The table below reports the earnings per share of common stock for Home Depot Inc. for...

    The table below reports the earnings per share of common stock for Home Depot Inc. for 2003 through 2012.   Year Earnings per Share   2003 $ 1.31   2004 1.65   2005 2.00   2006 2.33   2007 2.81   2008 2.97   2009 3.10   2010 3.24   2011 2.07   2012 2.46 Develop an index, with 2003 as the base, for earnings per share for years 2004 through 2012. (Round your answers to 1 decimal place.) Year Simple index 2004     2005     2006     2007     2008...

  • The consumption function is one of the key relationships in economics, where consumption y depends on disposable income...

    The consumption function is one of the key relationships in economics, where consumption y depends on disposable income x. Consider the quarterly data for these seasonally adjusted variables, measured in billions of dollars. A portion of the data is shown in the accompanying table. Date Consumption Disposable Income DATE Consumption Disposable Income 2006:01 9144.90 9705.21 2006:04 9263.60 9863.81 2006:07 9262.60 9982.51 2006:10 9484.00 10111.23 2007:01 9635.00 10255.48 2007:04 9758.70 10358.61 2007:07 9854.20 10456.95 2007:10 9986.50 10623.42 2008:01 10071.30 10764.62 2008:04...

  • Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past...

    Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Year Sales 2005 2006 2007 2008 2009 450 495 518 563 580 Forecasted Sales 410.00 422.00 443.90 466.13 495.19 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 73.76 sales (round...

  • Number of Certified Organic Farms in the U.S., 2001-2008 Year Spending 2001 5,153 2002 5,454 2003...

    Number of Certified Organic Farms in the U.S., 2001-2008 Year Spending 2001 5,153 2002 5,454 2003 6,178 2004 6,150 2005 6,598 2006 7,486 2007 9,248 2008 11,043 Number of Certified Organic Farms in the United States, 2001–2008 Year Farms 2001 5,153 2002 5,454 2003 6,178 2004 6,150 2005 6,598 2006 7,486 2007 9,248 2008 11,043 (a) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time series. (A negative value should be indicated by a...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT