Anwser the question below based on Patrick Inustries company information from yahoo finance

calculate the average return of each stock

the standard deviation of each stock

calculate the covariance and correlation between each pair of stocks

calculate beta for each stock one time using the beta equation and the second time using

the regression

Form groups of 4 or 5 students only, individual submissions are not accepted.

Due date: January 17th, 2020, by 3:00 pm.

Submit a soft copy of the answers to the questions below via ITC.

The excel files sent via ITC should be named with the group members names as follows:

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 portfoli