Answered step by step
Verified Expert Solution
Question
1 Approved Answer
KNOWLEDGE CHECK Which of the following stocks is LEAST sensitive to the movement of the overall stock market? Starbucks Home Depot Amazon Click to open/close
KNOWLEDGE CHECK Which of the following stocks is LEAST sensitive to the movement of the overall stock market? Starbucks Home Depot Amazon Click to open/close each chart. Intel > HOME DEPOT INC Equ... BETA - Related Functions Menu Message *CO? HD US $ | 135.28 -.37 mm T135.27 /135.297 5x4 ... At 15:35 d Vol 2,699,179 0 135.09N H 136.24D L 134.88T Val 365.28M HD US Equity Relative Index SPX Index 98 Actions 9 7) Edit Historical Beta Data Last Price Data Last Price Wkly Linear Beta +/- Non-Param Reg on Percent 04/23/2011 . 04/20/2010 - 04/27/2013 - 04/27/2015 Lago Winsorize 2 Std Dev Local 6M YTD 1Y 2Y SY Max Weekly >> Statistics Transformations Legend + Track 2 Annotate a Zoom S elect Copy Y = HOME DEPOT INC |x - S&P 500 INDEX Y = 0.969 X + 0.362 Linear Beta Range 1 Raw BETA 0.969 Adjusted BETA 0.980 ALPHA (Intercept) 0.362 R^2 (Correlation^2) 0.476 R (Correlation) 0.690 Std Dev of Error 2.068 Std Error of ALPHA 0.129 Std Error of BETA 0.063 t-Test 15.268 Significance 0.000 -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 Last T-Value -0.429 Last P-value 0.334 SPX Index-Percent Number of Points 259 Select Last Spread 1945.72 Last Ratio 0.065 HD US Equity-Percent 2000 1500 Weekly: 04/29/11 - 04/15/16 HD US Equity 135.0 SPX index 2080.73 984 1989 1994 2004 2009 INTEL CORP Equity BETA - Related Functions Menu Message * Co.? INTC US$ 131.3393 - .051 wa K31.33/31.34% 32x188 ... At 15:36 d Vol 16,822,032 031.39 H 31.70D (31.17Q Val 528.03M INTC US Equity Relative Index SPX Index 90) Actions 9 7) Edit Historical Beta Data Last Price Data Last Price Wkly Linear Beta +/- Non-Param Reg On Percent 04/23/2011 - - 04/20/2016 04/27/2013 - 04/27/2015 - Lag Winsorize 2 Std Dev Local 6M YTD 1Y 2Y SY Max Weekly >> Statistics Transformations Legend + Track Annotate , Zoom S elect Copy Y - INTEL CORP |X - S&P 500 INDEX Y = 1.063 X -0.025 Linear Beta Range 1 Raw BETA 1.063 | Adjusted BETA 1.042 ALPHA (Intercept) -0.025 R^2 (Correlation^2) 0.446 R (Correlation) 0.668 Std Dev of Error 2.408 Std Error of ALPHA 0.150 Std Error of BETA 0.074 t-Test 14.381 Significance 0.000 -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 Last T-Value -0.925 Last P-value 0.178 SPX Index-Percent Number of Points 259 * Select Last Spread 2049.27 Last Ratio 0.015 INTC US Equity-Percent 1500 Weekly: 04/29/11 - 05/15/16 INTC US Equity 31.45 SPX Index 2080.73 1989 1994 STARBUCKS CORP Equ... BETA Related Functions Menu Message *CO? SBUX US $ 57.77 were me 57.77 /57.78Q 21x7 At 15:36 d Vol 7.385.265 58.050 H 58.67D 57.560 Val 428.031M SBUX US Equity Relative Index SPX Index 90 Actions - 97) Edit . Historical Beta Data Last Price Data Last Price Wkly Linear Beta / Non-Param Reg on Percent 04/23/2011 - - 04/20/2016 - 04/27/2013 - 04/27/2015 Lag Winsorize 2 Std Dev Local 6M YTD 1Y 2Y SY Max Weekly >> Statistics Transformations E Legend Track Annotate , Zoom S elect Copy Y = STARBUCKS CORP |X = S&P 500 INDEX Y-0.860 X + 0.356 Linear Beta Range 1 Raw BETA 0.860 Adjusted BETA 0.907 ALPHA (Intercept) 0.356 R^2 (Correlation^2) 0.321 R (Correlation) 0.567 Std Dev of Error 2.540 Std Error of ALPHA 0.158 Std Error of BETA 0.078 t-Test 11.031 Significance 0.000 -3 -2 -1 0 1 2 3 4 5 Last T-Value -1.027 Last P-value 0.153 SPX Index-Percent Number of Points * Select Last Spread 2020.22 Last Ratio 0.029 SBUX US Equity-Percent 259 2000 11500 Weekly: 04/29/11 - 04/15/16 SBUX US Equity 60.51 SPX index 2080.73 1994 1999
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started