In: Finance
| You have been given the following information: | 
| Rate of Return If State Occurs | |||||||||
| State of | Probability of | ||||||||
| Economy | State of Economy | Stock A | Stock B | ||||||
| Recession | .16 | .05 | − | .16 | |||||
| Normal | .62 | .08 | .13 | ||||||
| Boom | .22 | .13 | .30 | ||||||
| a. | 
 Calculate the expected return for the two stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)  | 
| b. | Calculate the standard deviation for the two stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) | 
Please refer to below spreadsheet for calculation and answer of (a) & (b) . cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.