Expected return, stardard deviation, and capital asset pnicing mode) The following are the end -month prices for both the Standard 8 Poor's 500 index and Nixe's convion stock. 1. Using the dati in the popup window. calculate the holding-period returns for each of the months. b. Culculate the average monthy return and the standard deviation for both the S8P 500 and Nike. c. Develop a graph that shows the relationship between the Nike stock returns and the SaP 500 index. (Show the Nike returns on the wertical axis and the S8P 500 indaxratums on the horizontal axis ) d. From your graph, describe the nature of the relationship between Nike stock retums and the celums for the S8P 500 Index (Round to two decimal places.) \begin{tabular}{lrr} \hline 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 \\ \hline \end{tabular}