Q1. Collect the data from "Yahoo Finance" and answer the following questions (using the instructions given in the next page): a) 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 separately in a table. (2 marks)b) Calculate the return of share prices and market return (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, and . (2 marks)c) Calculate the mean, standard deviation, variance, coefficient of variation and correlation coefficient for and separately (for two sub-period in a table) and comment on the result. (1+2=3 marks, 1 for calculation 2 for the comment)d) Estimate beta for your selected company for the two sub-periods. (2 marks)e) Explain the value of beta that you have calculated. (2 marks).f) Why the estimated value of beta is different for two sub-periods?