For all data questions: You may use R, Python, Stata, or any other language to complete this part. However, you may not use spreadsheets such as MS Excel. 1. Markowitz model [Hints: (i). Perform your analysis in terms of returns, not prices, (ii). You may solve c) and d) either analytically (i.e. inserting the estimates into the formulas) or numerically (i.e. making a vector of portfolio weights with many elements, and calculating the properties of the portfolio for each portfolio weight)] a) Download the monthly stock price data of Apple Inc. and Boeing Company from finance.yahoo.com (finding exactly what is part of the task). The datasets contain several stock price measures. Use the adjusted close price, which correctly account for dividends and stock splits. b) Calculate the historical expected return and standard deviation of returns for each of the stocks between Jan 2000 and Dec 2020. Plot them in a Markowitz diagram. c) Plot the Markowitz bullet that you can generate by investing into these two stocks only. d) Suppose you want to invest only in Apple and Boeing, but with the minimal achievable portfolio risk. What fraction of your money do you put in Apple, what fraction do you put into Boeing? Answer based on the Jan 2000 to Dec 2020 data. For all data questions: You may use R, Python, Stata, or any other language to complete this part. However, you may not use spreadsheets such as MS Excel. 1. Markowitz model [Hints: (i). Perform your analysis in terms of returns, not prices, (ii). You may solve c) and d) either analytically (i.e. inserting the estimates into the formulas) or numerically (i.e. making a vector of portfolio weights with many elements, and calculating the properties of the portfolio for each portfolio weight)] a) Download the monthly stock price data of Apple Inc. and Boeing Company from finance.yahoo.com (finding exactly what is part of the task). The datasets contain several stock price measures. Use the adjusted close price, which correctly account for dividends and stock splits. b) Calculate the historical expected return and standard deviation of returns for each of the stocks between Jan 2000 and Dec 2020. Plot them in a Markowitz diagram. c) Plot the Markowitz bullet that you can generate by investing into these two stocks only. d) Suppose you want to invest only in Apple and Boeing, but with the minimal achievable portfolio risk. What fraction of your money do you put in Apple, what fraction do you put into Boeing? Answer based on the Jan 2000 to Dec 2020 data