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