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?