You are presented with eight (8) stocks and their prices from 27th January 2015 to 2nd February 2015 B D E F G H 325.72 327.40 355.81 325.91 53.89 56.06 59.74 53.08 DAY 2/5/2015 1468.36 2/4/2015 1481.14 2/3/2015 1549.38 2/2/2015 1526.75 2/1/2015 1473.99 1/31/2015 1455.27 1/30/2015 1503.35 1/29/2015 1530.62 1/28/2015 1482.37 1/27/2015 1420.86 46.62 6456.90 8067.32 15307.78 2151.73 2745.83 6432.50 7870.52 15680.67 2207.16 2688.33 6721.60 8019.22 16737.63 2351.44 2643.49 6466.80 7861.51 16785.69 2187.97 2359.21 6303.30 7638.17 16569.09 2062.08 2194.34 6360.10 7584.14 | 17248.89 2180.25 2348.67 6607.90 8007.32 18138.36 2190.87 2139.28 6621.40 7883.04 17875.75 2243.03 2084.32 6449.20 7408.87 17400.41 2154.55 1999.17 6308.00 6917.03 17287.65 2102.78 1830.92 303.02 316.36 48.18 303.26 47.37 46.10 292.65 276.41 263.38 41.40 39.68 calculate the following i. Calculate the holding periods returns (HPR) for each day ii. Calculate the holding periods yields (HPY) for each day a. Using your answer in part ii, calculate the overall HPY for each stock b. Using your answers in parts a & b calculate the standard deviation of each stock c. Which stocks would you prefer according to HPY and according to Standard Deviation? iii. Calculate the coefficient of variation for each stock? Which stock between the eight (8) would you select as the best investment? iv. Calculate the correlation coefficients of two asset combinations from the eight (8) stocks You wish to construct a portfolio consisting of any of the two assets. Which two asset combinations would you prefer? Validate your reasons with statistical data? V