Mineral Resources Group (MRG) has been listed on the Toronto Stock Exchange many years. However, you decided that data before 2007 is no longer relevant to MRG. Therefore, the following year-end prices and dividends are most relevant to your analysis:

Row 1	Year-end	2012	2013	2014	2015	2016
Row 2	Price	51.1	53.25	39.38	54.67	58.86
Row 3	Dividend	0.75	0.75	0.85	0.85	1.05
Row 4	TSX Index	13128	15100	11388	12918	13745
Row 5	MRG Return
Row 6	TSX Return

a.) Fill as many cells as the data permits from Rows 5 and 6 of the table. (6 marks)

b.) What are the arithmetic average return and the geometric average return for MRG for the past 4-year period? (4 marks)

c.) Using the arithmetic average, what is the standard deviation for MRGs returns? (3 marks)

d.) Assuming the TSX index is the market against which to measure the risk of MRG, what is the correlation between the returns on MRG and the market and what is the beta of MRG? (4 marks) Hint: You need to use excel or your calculator for this exercise. In Excel, (1) arrange the MRG returns and the TSX returns in two columns. (2) Use the statistical function Correl in Excel to get the correlation coefficient. (3) Go to data, then data analysis, and from the table highlight regression. Then activate OK. A table with instructions appears. (4) Follow the instructions. Make sure to enter the MRG returns data as the Y Range data and the TSX returns data as the X Range. The beta will be the coefficient of X Variable 1.

Correlation coefficient = , Beta =