(Please use excel function to answer)

a) Refer to the table below. Based on the risk, return and covariance of the RSJ and QLR shares, display the weights of the minimum variance portfolio comprising only these two shares. (2 marks)

Statistics based on monthly returns
	RSJ	QLR
Average	2.47%	2.05%
Variance	0.29%	0.34%
St. Deviation	5.37%	5.81%
Covariance	0.00128

(b) Assume that the return and standard deviation of minimum variance portfolio in part (a) is 1.40% and 4.68%, respectively; and the return of a risk-free asset is 1.05% per month. Display the return and standard deviation of a portfolio combining in equal weights the minimum variance portfolio and a risk-free asset. (2 marks)

(c) Based on the template below, construct a Data Table showing variations in the return and standard deviation of a portfolio combining the minimum variance portfolio with a risk-free asset in part (b) (no marks for entering individual formulae into the table). (2 marks)

			Data Table
	Minimum Variance Portfolio	Risk-free asset	Return	St. Deviation
Weights	0%	100%
	10%	90%
	20%	80%
	30%	70%
	40%	60%
	50%	50%
	60%	40%
	70%	30%
	80%	20%
	90%	10%
	100%	0%

(d) Draw the line of this graph of returns (on the vertical axis) and risk (on the horizontal axis) based on the table in part (c). (2 marks)