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

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

Data Analysis And Sampling Simplified A Practical Guide For Internal Auditors

Authors: Donald A. Dickie PhD

1st Edition

1634540611, 978-1634540612

More Books

Students also viewed these Accounting questions