calculate the correlation between Equities and Commercial Property. Comment on the implications of your correlation calculation if you wanted to diversify a portfolio which contained both 50% weight in commercial property and 50% in equities.

Q1a) An investor has collated nine returns from their portfolio. Calculate the following for each asset class (Commercial Property, Equities and Corporate bonds); mean, median, mode, variance, standard deviation. Show your workings and briefly comment on your results
Table 1. Returns in 2022 for Commercial Property, Equities, and Government Bonds
Commercial Property Equities Government bonds 8% 12% 4% 10% 14% 3% -12% 19% 2% 4% -15% 1% 6% -1% 4% 7.5% 0% 5% 3% 15% 8% 5% 14% 6% 4% 3% 4%
(15 marks)

Q1b) Using the information in Table 1, calculate the correlation between Equities and Commercial Property. Comment on the implications of your correlation calculation if you wanted to diversify a portfolio which contained both 50% weight in commercial property and 50% in equities.