Using the FTSE Indices Total Return data provided produce a spreadsheet that contains:
a)The monthly total returns for each index, the mean return over the period, and the standard deviation of those returns.
b. Construct the Correlation Matrix for the three indices:
c. Create charts showing the possible risk and return combinations of 2 indices for each of the 3 different combinations
d. Calculate the minimum possible risk attainable for each of the 3 combinations of investing in 2 indices. What return is earned for each of these 3 combinations?