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%

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.

Question content area bottom

Part 1

1. The estimated monthly beta for Nike is what?