The return on Visa stock has a standard deviation of 30% and the return on Walmart stock has a standard deviation of 21%. Their correlation is 0.67.
If you invest 80% in Visa and 20% in Walmart, what is the variance of the portfolio?
What is the standard deviation of the portfolio?
If possible, can you show how to solve in excel.