Transcribed Image Text
Below is actual price and dividend data for three companies foreach of seven months.Security ASecurity BSecurity CTimePriceDividendPriceDividendPriceDividend1$48.27$25.50$178.002$49.10$23.85$165.003$52.60$2.50$19.95$2.50$174.00$15.004$51.35$24.65$182.005$53.25$25.10$183.006$53.92$2.25$22.78$2.50$187.00$12.507$52.00$26.18$193.00A. Compute the rate of return for each company for each month (usesimple return formula).B. Computethe average rate of return for each company.C. Computethe standard deviation of the rate of return for each company(use population variance formula. i.e. divide by N, not(N-1) ).D. Computethe covariance and correlation coefficients between all possiblepairs of securities (again, use population formula).E. Computethe average return and standard deviation for the followingportfolios: i. ½ A + ½ B ii. ½ A + ½ C iii. ½ B + ½ C iv. 1/3 A + 1/3 B + 1/3 C