Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance For Musicians

Authors: Bobby Borg

1st Edition

1538163306, 978-1538163306

More Books

Students also viewed these Finance questions