WhatsApp +1 (332) 244-5747

Expected return and standard deviation

Get your custom paper done at low prices


275 words/page


Double spacing


Free formatting (APA, MLA, Chicago, Harvard and others)


12 point Arial/Times New Roman font


Free title page


Free bibliography & reference

Can someone show me how to solve this in Excel? 25-3) Stock A has an expected return of 12% and a standard deviation of 40%. Stock B has an expected return of 18% and a standard deviation of 60%. The correlation coefficient between Stock A and B is 0.2. What are the expected return and standard deviation of a portfolio invested 30% in Stock A and 70% in Stock B?Weight of Stock A (WA) = 30% = 0.30Weight of Stock B (WB) = 70% = 0.70Expected return of Stock A (ERA) = 12% = 0.12Expected return of stock B (ERB) = 18% = 0.18Standard deviation of stock A…


What Students Are Saying

Outstanding service, thank you very much.

Undergraduate Student

English, Literature

Awesome. Will definitely use the service again.

Master's Student

Computer Science