Q1.Collect the data from "Yahoo Finance" and answer the following questions

1. Collect the market price index (All Ordinaries), Share price for a company (as per instructions given in page 2) and display the data for two sub-periods (Period 1: February 2014 to February 2016; Period 2: October 2016 to October 2018) separately in two separate tables.
2. Calculate the return of share prices (Rj) and market return (Rm)(from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate(Rj - Rf) and (Rm - Rf )
3. Calculate the mean, standard deviation, variance and correlation coefficient for (Rj - Rf)and (Rm- Rf) separately (for two sub-period in a table-see next page) and comment on the result.