[Statistics] You are interested in two investment, Fidelity Capital and Income (FAGIX), and Fidelity Low Price Stock Fund (FLPKX). The followings are their 12 month returns in 2017 that I have recorded from finance.yahoo.com : (a) What are the average returns of the two funds? (b) What are the return volatilities of the two funds? (c) Compute the covariance and correlation between returns of the two funds. (d) Plot the returns of FLPKX against the returns of FAGIX (using Excel). Do you see a relationship between the two? From Fin6301, why do you think there is or is not a relation? (e) Compute the regression line: RFLPKX=+RFAGIX, using the formulas in Lecture Note 1 , and plot the line on the same graph in (d). What do you observe? (f) Using regression analysis in Excel, find the linear relationship between the returns of the two funds, i.e. regressing returns of FLPKX on returns of FSTMX. [Statistics] You are interested in two investment, Fidelity Capital and Income (FAGIX), and Fidelity Low Price Stock Fund (FLPKX). The followings are their 12 month returns in 2017 that I have recorded from finance.yahoo.com : (a) What are the average returns of the two funds? (b) What are the return volatilities of the two funds? (c) Compute the covariance and correlation between returns of the two funds. (d) Plot the returns of FLPKX against the returns of FAGIX (using Excel). Do you see a relationship between the two? From Fin6301, why do you think there is or is not a relation? (e) Compute the regression line: RFLPKX=+RFAGIX, using the formulas in Lecture Note 1 , and plot the line on the same graph in (d). What do you observe? (f) Using regression analysis in Excel, find the linear relationship between the returns of the two funds, i.e. regressing returns of FLPKX on returns of FSTMX