Use the data table, _ , to estimate the beta of Nike (NKE) and HP (HPQ) 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.) (Click on the following icon in order to copy its contents into a spreadsheet.) Dec-12Jan-13Feb-13Mar-13Apr-13May-13Jun-13Jul-13Aug-13Sep-13Oct-13Nov-13Dec-13Jan-14Feb-14Mar-14Apr-14May-14Jun-14Jul-14Aug-14Sep-14Oct-14Nov-14Dec-14Jan-157.591%4.748%1.536%8.355%7.778%2.390%3.276%1.193%0.509%15.632%4.295%4.461%0.025%7.363%8.140%5.671%1.232%6.086%0.832%0.542%2.463%13.558%4.226%6.798%2.598%4.056%11.937%15.860%21.987%19.815%13.591%18.544%2.865%3.548%13.006%4.612%16.103%12.228%3.473%3.645%3.034%9.370%2.163%1.331%1.589%5.730%6.712%5.731%1.156%8.863%3.641%9.968%0.902%5.119%1.276%3.795%1.921%2.361%1.340%5.168%2.999%3.176%4.631%2.964%2.580%3.525%4.552%0.829%0.695%2.321%2.064%1.344%3.946%1.371%2.355%2.747%0.253%2.963% Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-175.886%3.305%1.485%3.430%6.246%6.665%3.012%10.541%6.554%0.954%5.020%0.784%0.677%0.065%4.116%6.311%0.254%0.543%3.856%8.380%4.691%0.219%1.877%4.072%8.053%2.187%3.570%9.551%5.809%1.304%8.989%1.699%8.060%7.350%5.271%2.422%4.593%17.990%10.093%16.408%0.406%9.046%5.277%11.633%2.570%8.935%6.697%6.280%2.775%1.415%15.415%3.700%5.620%1.566%0.983%1.286%1.999%2.215%6.134%2.489%8.529%0.366%1.729%4.979%0.083%6.721%0.394%1.701%0.342%3.647%0.120%0.001%1.734%3.684%2.032%1.789%3.929%0.128% \begin{tabular}{crrr} 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% \\ \hline \end{tabular}