Note: Although not absolutely necessary, you are advised to use a computer spreadsheet to work the foliowing problem. a. Use the price data from the table in the popup window, , for the Standard \&. Poor's 500 Index, Waimart, and Target to calculate the holding-period retums for the 24 months from May 2013 through May 2015. b. Calculate the average monthly holding-period returns and the standard deviation of these retums for the S8P 500 index, Waimart, and Target. c. From the following graphs, describe the nature of the relationship between the stock returns for Walmart and the rotums for the S&P.500 index. d. Assume that you have decided to invest one half of your money in Walmart and the remainder in Targot. Calculate the monthly holding-period returns for your fwo-stock portfolio. (Hint: The monthly return for the portiolio is the average of the two stocks' monthly returns.) e. The table in the popup window, shows the returns on an annualizod basis that were reaized from holding long-term government bonds for the same period. Calculate the average monthly holding-period roturns and the standard doviations of these retums. (Hint: You will need to convert the annual returns to monthly returns by dividing each rotum by 12 months.) 1. Now assuming that you have decided to invest equal amounts of money in Walmart, Target, and long-term government securites, calculate the monthly retums for your three-assot portfolio. What are the average return and the standard deviation? a. Calculate the monthy holding-period retums (MPR) for the Standard \& Poors 500 index for the 24 months from May 2013 through May 2015 in the following table. Enter a negative number if the holding-period return is negative. (Round to two decimal places.) Data table (Click on the following icon D in order to copy its contents into a spreadsheet.)