Using the data and your results from Question $1$:

a$)$ Create the full covariance matrix for the four stocks

in Question $1.$

Create the covariance in a new worksheet, then copy the values

back to the yellow spaces provided in this worksheet.

b$)$ Per the expected semi$-$annual return shown below,

set up the Markowitz' Equations in an Excel formatted

tables as shown in the lectures $($matrix and a vector$).$

Use the expected semi$-$annual return shown below, and

use $252$ as the total days per year; $126$ days semi$-$annual.

Please put your results in the highlighted yellow cells

in the provided Markowitz' Equation tables.