Minimum Variance Portfolio (the risk return trade off with two risky assets portfolios)
So I've been trying to figure out how to display the minimum variance of a portfolio, but I don't know how to graph it using Solver (or any Excel tool).
I already added Solver and I have calculated the mean and standard deviation of the minimum variance portfolio in the end, but I also want to have a nice graphical display.
Also, how can one draw a tangent line from the risk free-rate (let's say 6%) to the opportunity set?
* The "s" abbreviation stands for standard deviation, I need to fix it.
Thanks a lot to anyone who is willing to share some advise.
| Attachment | Size |
|---|---|
| problem 1.PNG | 121.21 KB |

Recent comments
6 years 36 weeks ago
7 years 22 weeks ago
7 years 34 weeks ago
7 years 37 weeks ago
7 years 38 weeks ago
7 years 43 weeks ago
7 years 51 weeks ago
8 years 1 day ago
8 years 1 day ago
8 years 2 days ago