Question

In: Statistics and Probability

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...

PepsiCo Revenues ($ millions), 2005–2010
Quarter 2005 2006 2007 2008 2009 2010
Qtr1 6,585    7,205    7,350    8,333 8,263   9,368
Qtr2 7,697    8,599    9,607    10,945 10,592   14,801
Qtr3 8,184    8,950    10,171    11,244   11,080   15,514
Qtr4 10,096    10,383    12,346    12,729   13,297  

18,155

(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

Solutions

Expert Solution

data

y t q1 q2 q3
6585 1 1 0 0
7697 2 0 1 0
8184 3 0 0 1
10096 4 0 0 0
7205 5 1 0 0
8599 6 0 1 0
8950 7 0 0 1
10383 8 0 0 0
7350 9 1 0 0
9607 10 0 1 0
10171 11 0 0 1
12346 12 0 0 0
8,333 13 1 0 0
10,945 14 0 1 0
11244 15 0 0 1
12729 16 0 0 0
8263 17 1 0 0
10592 18 0 1 0
11080 19 0 0 1
13297 20 0 0 0
9,368 21 1 0 0
14,801 22 0 1 0
15,514 23 0 0 1
18,155 24 0 0 0
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.927608978
R Square 0.860458416
Adjusted R Square 0.83108124
Standard Error 1171.697178
Observations 24
ANOVA
df SS MS F Significance F
Regression 4 160846126.6 40211531.64 29.29003209 6.8748E-08
Residual 19 26084611.27 1372874.277
Total 23 186930737.8
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 8973.2833 684.8834778 13.1019124 5.79529E-11 7539.80574
t 275.7893 35.01114972 7.877184494 2.10729E-07 202.5101072
q1 -4156.2988 684.5851186 -6.071266665 7.72107E-06 -5589.15193
q2 -1909.2548 680.0940241 -2.807339418 0.011242418 -3332.707914
q3 -1701.3774 677.3850749 -2.511684187 0.021211076 -3119.160637

y^= 8973.2833 + 275.7893 T -4156.2988 Q1 -1909.2548 Q2 -1701.3774 Q3


Related Solutions

PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205   ...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585    7,205    7,350    8,332 8,263   9,368 Qtr2 7,697    8,599    9,607    10,945 10,592   14,801 Qtr3 8,184    8,950    10,171    11,244   11,080   15,514 Qtr4 10,096    10,383    12,346    12,729   13,297   18,155 (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 =___...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090 7,410 7,180 7,516 Qtr2 6,310 6,480 7,720 9,060 8,232 8,665 Qtr3 6,037 6,422 7,677 8,314 8,040 8,417 Qtr4 5,551 5,920 7,318 7,100 7,498 10,485 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.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075 7,380 7,150 7,800 Qtr2 6,304 6,465 7,705 9,045 8,220 8,659 Qtr3 6,031 6,410 7,662 8,305 8,025 8,411 Qtr4 5,545 5,905 7,303 7,040 7,480 10,479 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006 2007 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account Assumptions​ (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 ​Goods: exports ​77,939 ​102,175 ​123,876 ​153,530 ​199,065 ​167,958 ​230,967 ​307,847 ​298,321 ​319,110 ​329,633 ​Goods: imports ​-95,539 ​-134,692 ​-166,572 ​-208,611 ​-291,740 ​-247,908 ​-324,320 ​-428,021 ​-450,249 ​-433,760 ​-415,529      Balance on goods ​-17,600 ​-32,517 ​-42,696 ​-55,081 ​-92,675 ​-79,950 ​-93,353 ​-120,174 ​-151,928 ​-114,650 ​-85,895 ​Services: credit ​38,281 ​52,527 ​69,440 ​86,552 ​106,054 ​92,889 ​117,068 ​138,528 ​145,525 ​148,649 ​156,252 ​Services: debit ​-35,641 ​-47,287 ​-58,514 ​-70,175 ​-87,739 ​-80,349 ​-114,739 ​-125,041...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $         7.46 $         7.91 $         8.38 $         8.80 $         9.24 $         9.70 $       10.28 $       10.79 $       11.33 $       12.01 Find both the arithmetic growth rate and the geometric growth rate of the dividends for Davy's Crock Pot Stores. Assuming the January​ 1, 2011 price of the stock is $110.00​, determine the current required rate of return for the company​ (use the geometric growth rate to calculate the...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009 59994 2010 61515 2011 63182 2012 67989 2013 70448 2014 72601 2015 75482 2016 78341 2017 81111 2018 82517 2019 83275 2020 84005 I. (a) Determine the trend line using both linear and two nonlinear equations Hint: You can choose any two of the nonlinear options in edit trend lines within Tableau. (b) Write down the equations (coefficients). Hint: Double click on trend line...
Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES:...
Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES: Equity share capital 400,000 600,000 500,000 400,000 600,000 Long term loan 500,000 250,000 300,000 400,000 300,000 Sundry creditors 200,000 300,000 350,000 340,000 250,000 Short term loan 50,000 40,000 60,000 115,000 50,000 ASSETS: Land and Building 300,000 500,000 600,000 700,000 450,000 Furniture 600,000 450,000 400,000 400,000 500,000 Cash at bank 50,000 60,000 70,000 50,000 70,000 Stock 140,000 150,000 100,000 80,000 120,000 Prepaid expenses 60,000 30,000...
Year Quarter Revenue 2005 Qtr1 5,200 Qtr2 6,296 Qtr3 6,023 Qtr4 5,537 2006 Qtr1 5,103 Qtr2...
Year Quarter Revenue 2005 Qtr1 5,200 Qtr2 6,296 Qtr3 6,023 Qtr4 5,537 2006 Qtr1 5,103 Qtr2 6,445 Qtr3 6,394 Qtr4 5,885 2007 Qtr1 6,055 Qtr2 7,685 Qtr3 7,642 Qtr4 7,283 2008 Qtr1 7,340 Qtr2 9,025 Qtr3 8,293 Qtr4 7,005 2009 Qtr1 7,110 Qtr2 8,204 Qtr3 8,005 Qtr4 7,456 2010 Qtr1 7,600 Qtr2 8,651 Qtr3 8,403 Qtr4 10,471 (a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola’s quarterly data. (Round your answers to 3 decimal places.) 1 2 3 4 2005 2006...
Cash Flow Data for Interceptors, Inc. 2005 2006 2007 2008   Cash $ 40 $ 50 $...
Cash Flow Data for Interceptors, Inc. 2005 2006 2007 2008   Cash $ 40 $ 50 $ 60 $ 70   Cash from operations $ 132 $ 130 $ 127 $ 122   Net capital spending $ 150 $ 145 $ 150 $ 155   Cash from financing $ 28 $ 25 $ 33 What must cash flow from financing have been in 2008 for Interceptors, Inc.? $33 $43 $10 $40
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT