Question
Use the data table to estimate the beta of Nike and HP Inc. stock based on their monthly returns from 2011-2017. Hint: You can use
Use the data table to estimate the beta of Nike and HP Inc. stock based on their monthly returns from 2011-2017.
Hint: You can use the slope() function in Excel.
The estimated monthly beta for Nike is _____. (Round to three decimal places.)
Date | NKE | HPQ | S&P 500 |
Jan-11 | 3.442% | 8.527% | 2.330% |
Feb-11 | 7.941% | 4.509% | 3.474% |
Mar-11 | 13.580% | 5.693% | 0.005% |
Apr-11 | 8.745% | 1.464% | 2.896% |
May-11 | 2.587% | 7.406% | 1.121% |
Jun-11 | 8.017% | 1.915% | 1.706% |
Jul-11 | 0.189% | 3.379% | 2.000% |
Aug-11 | 3.882% | 25.988% | 5.498% |
Sep-11 | 0.115% | 12.738% | 6.910% |
Oct-11 | 12.677% | 18.530% | 10.915% |
Nov-11 | 0.176% | 5.036% | 0.406% |
Dec-11 | 1.695% | 6.890% | 1.024% |
Jan-12 | 7.907% | 8.618% | 4.637% |
Feb-12 | 3.779% | 9.543% | 4.341% |
Mar-12 | 1.816% | 4.803% | 3.214% |
Apr-12 | 3.163% | 3.903% | 0.668% |
May-12 | 2.011% | 8.401% | 6.006% |
Jun-12 | 18.857% | 10.050% | 4.045% |
Jul-12 | 6.345% | 9.299% | 1.183% |
Aug-12 | 5.838% | 7.456% | 2.505% |
Sep-12 | 2.516% | 2.788% | 2.543% |
Oct-12 | 3.719% | 18.816% | 1.820% |
Nov-12 | 6.675% | 6.209% | 0.566% |
Dec-12 | 7.591% | 11.937% | 0.902% |
Jan-13 | 4.748% | 15.860% | 5.119% |
Feb-13 | 1.536% | 21.987% | 1.276% |
Mar-13 | 8.355% | 19.815% | 3.795% |
Apr-13 | 7.778% | 13.591% | 1.921% |
May-13 | 2.390% | 18.544% | 2.361% |
Jun-13 | 3.276% | 2.865% | 1.340% |
Jul-13 | 1.193% | 3.548% | 5.168% |
Aug-13 | 0.509% | 13.006% | 2.999% |
Sep-13 | 15.632% | 4.612% | 3.176% |
Oct-13 | 4.295% | 16.103% | 4.631% |
Nov-13 | 4.461% | 12.228% | 2.964% |
Dec-13 | 0.025% | 3.473% | 2.580% |
Jan-14 | 7.363% | 3.645% | 3.525% |
Feb-14 | 8.140% | 3.034% | 4.552% |
Mar-14 | 5.671% | 9.370% | 0.829% |
Apr-14 | 1.232% | 2.163% | 0.695% |
May-14 | 6.086% | 1.331% | 2.321% |
Jun-14 | 0.832% | 1.589% | 2.064% |
Jul-14 | 0.542% | 5.730% | 1.344% |
Aug-14 | 2.463% | 6.712% | 3.946% |
Sep-14 | 13.558% | 5.731% | 1.371% |
Oct-14 | 4.226% | 1.156% | 2.355% |
Nov-14 | 6.798% | 8.863% | 2.747% |
Dec-14 | 2.598% | 3.641% | 0.253% |
Jan-15 | 4.056% | 9.968% | -2.963% |
Feb-15 | 5.886% | 3.570% | 5.620% |
Mar-15 | 3.305% | 9.551% | 1.566% |
Apr-15 | 1.485% | 5.809% | 0.983% |
May-15 | 3.430% | 1.304% | 1.286% |
Jun-15 | 6.246% | 8.989% | 1.999% |
Jul-15 | 6.665% | 1.699% | 2.215% |
Aug-15 | 3.012% | 8.060% | 6.134% |
Sep-15 | 10.541% | 7.350% | 2.489% |
Oct-15 | 6.554% | 5.271% | 8.529% |
Nov-15 | 0.954% | 2.422% | 0.366% |
Dec-15 | 5.020% | 4.593% | 1.729% |
Jan-16 | 0.784% | 17.990% | 4.979% |
Feb-16 | 0.677% | 10.093% | 0.083% |
Mar-16 | 0.065% | 16.408% | 6.721% |
Apr-16 | 4.116% | 0.406% | 0.394% |
May-16 | 6.311% | 9.046% | 1.701% |
Jun-16 | 0.254% | 5.277% | 0.342% |
Jul-16 | 0.543% | 11.633% | 3.647% |
Aug-16 | 3.856% | 2.570% | 0.120% |
Sep-16 | 8.380% | 8.935% | 0.001% |
Oct-16 | 4.691% | 6.697% | 1.734% |
Nov-16 | 0.219% | 6.280% | 3.684% |
Dec-16 | 1.877% | 2.775% | 2.032% |
Jan-17 | 4.072% | 1.415% | 1.789% |
Feb-17 | 8.053% | 15.415% | 3.929% |
Mar-17 | 2.187% | 3.700% | 0.128% |
Apr-17 | 0.574% | 5.257% | 0.993% |
May-17 | 4.367% | 0.319% | 1.411% |
Jun-17 | 11.681% | 6.116% | 0.639% |
Jul-17 | 0.085% | 9.268% | 2.055% |
Aug-17 | 10.262% | 0.105% | 0.292% |
Sep-17 | 1.818% | 5.308% | 2.010% |
Oct-17 | 6.056% | 7.966% | 2.356% |
Nov-17 | 9.875% | 0.464% | 3.057% |
Dec-17 | 3.856% | 1.402% | 1.208% |
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