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