The correlation between Stocks A and B is -.4794. If you only invest 25% in A and 75% in B, what is your portfolio Standard Deviation?

Please show your work in excel if possible!

Year Stock A (percent) Stock B (percent) Stock C (percent) Stock D (percent) Consumer Confidence Index 1 11.1 4.2 5.3 3.2 78.5 N 12.4 7.1 8.4 2.5 83.1 3 13.8 5.9 9.1 9.1 85.2 4 6.2 11.2 2.1 6.2 73.3 5 -3.1 8.3 -5.4 6.9 77.3 6 -2.0 12.4 .9 7.1 80.2 7 7.1 15.3 11.2. 79 83.3 00 8 8.7 12.1 8.2 8.1 86.1 9 10.3 1.1 15.3 9.2 90.4 10 11.6 4.5 12.0 6.2 87.4