In: Finance
a. Using the data in the popup window,
LOADING...
, calculate the holding-period returns for each of the months.
b. Calculate the average monthly return and the standard deviation for both the S&P 500 and Nike.
c. Develop a graph that shows the relationship between the Nike stock returns and the S&P 500 Index. (Show the Nike returns on the vertical axis and the S&P 500 Index returns on the horizontal axis.)
d. From your graph, describe the nature of the relationship between Nike stock returns and the returns for theS&P 500 Index.
;NIKE;S&P 500 INDEX
2017;;
January;52.90;2,279
February;57.16;2,364
March;55.73;2,363
April;55.41;2,384
May;52.99;2,412
June;59.00;2,423
July;59.05;2,470
August;52.81;2,472
September;51.85;2,519
October;54.99;2,575
November;60.42;2,648
December;62.55;2,674
2018;;
January;68.22;2,824