Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the data table to estimate the alpha of Nike and HP Inc. stock, expressed as % per month. (Hint: You can use the intercept()
Use the data table to estimate the alpha of Nike and HP Inc. stock, expressed as % per month. (Hint: You can use the intercept() function in Excel.).
The estimated monthly alpha for Nike is ____ (Round to two decimal places).
The estimated monthly alpha for HP Inc. ____(Round to two decimal places).
Monthly Returns Nike HP Inc. Date S&P 500 -3.442% 2.330% Jan-11 Feb-11 8.527% - 4.509% 3.474% 7.941% - 14.624% -0.005% 8.745% Mar-11 Apr-11 May-11 Jun-11 2.587% -5.913% - 1.465% - 7.406% -2.301% - 3.379% 2.896% - 1.121% - 1.706% 6.915% - 2.000% 0.189% - 3.882% - 25.988% Jul-11 Aug-11 Sep-11 Oct-11 - 0.958% - 13.292% -5.498% -6.910% 10.915% 12.677% 18.530% Nov-11 -0.176% -0.406% Dec-11 0.572% 1.024% Jan-12 7.907% 5.036% - 7.406% 8.618% -9.543% - 5.373% 4.637% 4.341% Feb-12 3.779% Mar-12 0.815% 3.214% -0.668% Apr-12 May-12 Jun-12 3.163% -2.977% 3.903% -8.401% - 10.750% - 18.857% 6.345% - 6.006% 4.045% 1.183% Jul-12 -9.299% Monthly Returns Nike HP Inc. Date S&P 500 -3.442% 2.330% Jan-11 Feb-11 8.527% - 4.509% 3.474% 7.941% - 14.624% -0.005% 8.745% Mar-11 Apr-11 May-11 Jun-11 2.587% -5.913% - 1.465% - 7.406% -2.301% - 3.379% 2.896% - 1.121% - 1.706% 6.915% - 2.000% 0.189% - 3.882% - 25.988% Jul-11 Aug-11 Sep-11 Oct-11 - 0.958% - 13.292% -5.498% -6.910% 10.915% 12.677% 18.530% Nov-11 -0.176% -0.406% Dec-11 0.572% 1.024% Jan-12 7.907% 5.036% - 7.406% 8.618% -9.543% - 5.373% 4.637% 4.341% Feb-12 3.779% Mar-12 0.815% 3.214% -0.668% Apr-12 May-12 Jun-12 3.163% -2.977% 3.903% -8.401% - 10.750% - 18.857% 6.345% - 6.006% 4.045% 1.183% Jul-12 -9.299%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