Note Athough not absolusely necessary, you are acthed to use a corputer speadsheet to work the follosing peoblem. a. Use the pike data from the table in the popup window 2013 through May 2015 e From the follouing graphis, describe the nature of the relationship between the stock retums for Wahsar and ele resums for the SSP 500 index monitily retam for the portilils is the average of the two stock' monthly ceturns) e. The table in the popup window. What are the avterge rutum and the standard deviation? Whal are the wowage coturn and the standard dentation? your corsparkon? return for the tor firme. (Click on the following icon in order to copy its contents into a spreadsheet.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) a. Calculate the monthly holding-period returns (HPR) for the Standard \& Poor's 500 Index \begin{tabular}{|c|c|c|} \hline Uct-13 & $1,/5/ & \\ \hline Nov-13 & $1,806 & 7% \\ \hline Dec-13 & $1,848 & 7% \\ \hline \begin{tabular}{|l|} Jan-14 \\ \end{tabular} & $1,783 & 7% \\ \hline Feb-14 & $1,859 & 7% \\ \hline Mar-14 & $1,872 & 7% \\ \hline Apr-14 & $1,884 & 7% \\ \hline May-14 & $1,924 & 7% \\ \hline Jun-14 & $1,960 & 7% \\ \hline Jul-14 & $1,931 & 7% \\ \hline Aug-14 & $2,003 & 7% \\ \hline Sep-14 & $1,972 & 7% \\ \hline Oct-14 & $2,018 & % \\ \hline Nov-14 & $2,068 & 7% \\ \hline Dec-14 & $2,059 & % \\ \hline Jan-15 & $1,995 & ]% \\ \hline Feb-15 & $2,105 & ]% \\ \hline \begin{tabular}{|l|} Mar-15 \\ \end{tabular} & $2,068 & % \\ \hline Apr-15 & $2,086 & 7% \\ \hline May-15 & $2,128 & ]% \\ \hline \end{tabular}