Please watch the Yahoo Finance and optimal allocation video to complete this assignment.

Go to the Yahoo Finance and pick stock prices for two companies that you would like to analyze.

Work with monthly data and the starting date should be January 2019.

1. Report the average return and standard deviation for both stocks.

2. Calculate the correlation coefficient between two stock returns.

3. Similar to in class exercise we did last time, please show how much would you invest in each stock if the objective is to maximize returns, minimize risk(variance), and maximize sharpe ratio. please show all your work in excel.