How did you construct your portfolio?

1- to continue the excel on analyzing the stock already chosen but  need to calculate the

1-EXPECTED RETURN/AVERAGE
2- Variance- Conariance metrix
3-a-min var
4-b-max return

5- wa, wb, var ,sd ,r

it is on the below there are 2 excela one the example and the other is mine to do the same on example

2- to answer the following questions :

  • How did you construct your portfolio?
  • Analyse the risk and return when you construct an equal weighting portfolio?
  • Analyse the risk and return when you construct a min-variance portfolio?
  • Analyse the risk and return when you construct a max-return portfolio?
  • Analyse the efficient frontier with your selection?