The correct answer for 25-1 is 1.4 and the answer for 25-3 is 16.2%; 45.9%. Can someone please assist me with solving the following homework questions in Excel?
1) The standard deviation of stock returns for Stock A is 40%. The standard deviation of the market is 20%. If the correlation between Stock A and the market is 0.70, then what is Stock A's beta?
2) 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?