can someone help with this i have up to two weeks

yearly

Part one 1:Risk and return (12 points) 1. Pick the companies Go to yahoo finance choose US companies which one company in the financial sector (bank), one industrial company one service and the index S&P500 get the adjusted closing price for the last 4 years starting Jan 1. 2015-Dec31, 2019 2. Use the excel to : calculate the average return of each stock the standard deviation of each stock calculate the covariance and correlation between cach pair of stocks calculate beta for each stock one time using the beta equation and the second time using the regression Calculate the average return of a portfolio that consist of 30% banks, 20% service companies and 50% industrial companies What is the portfolio risk for a portfolio consist of 40% banks and 60% service companies From It is given prices for the previous years 2019 - 31 Jan (1) to 2019 - Dec 31. yearly prices Part one 1:Risk and return (12 points) 1. Pick the companies Go to yahoo finance choose US companies which one company in the financial sector (bank), one industrial company one service and the index S&P500 get the adjusted closing price for the last 4 years starting Jan 1. 2015-Dec31, 2019 2. Use the excel to : calculate the average return of each stock the standard deviation of each stock calculate the covariance and correlation between cach pair of stocks calculate beta for each stock one time using the beta equation and the second time using the regression Calculate the average return of a portfolio that consist of 30% banks, 20% service companies and 50% industrial companies What is the portfolio risk for a portfolio consist of 40% banks and 60% service companies From It is given prices for the previous years 2019 - 31 Jan (1) to 2019 - Dec 31. yearly prices