PLEASE ANSWER USING EXCEL AND USE FORMULA TEXT

3. Cash Jones wants to invest in a portfolio composed of stocks ABC and XYZ (see below) that will yield a return of 19%. What is the weight of each stock in such a portfolio, and what is the portfolio's standard deviation? Answer the question both by using Goal Seek or Solver and the mathematical formulas. (take a screen shot of the Goal Seek or Solver parameters) I ABC XYZ Covariance(ABC,XYZ) Correlation(ABC XYZ) Expected return 15% 25% 0.0865 0.5698 Standard deviation of return 33% 46%