Normal .50 .06 .14 Boom .25 .10 .34 Fill in the value in the spreadsheet. Problem 2 Based on the following information, calculate the expected return and standard deviation: State of the Economy Probability Rate of Return Depression .15 -107 Recession 20 .069 Normal 40 .135 Boom 25 215 Fill in the values in the spreadsheet. Problem 3 Problem 4 Denham 5 Search II O C 99+ HUN TEISET Page Layout Formulas Data Review View Help Search Arial Number Paste Xcut La Copy- Format Painter BIU- - 12-AA = = Wrap Text E Merge Center - Alignment a A. $ . % 9-18 Insert Delete form Conditional Format as Cell Formatting Table - Styles Styles Clipboard Font Number Cels 021 f B C D G H J K - Input area: State Depression Recession Normal Boom Probability 0.15 0.20 0.40 0.25 Stock A -0.107 0.069 0.135 0.215 10 11 12 13 14 Output area: 15 16 Return Deviation Squared Deviation Probability Product Return Product 17 18 19 Stock A Depression Recession Normal Boom 20 21 0.0000 E(R) Variance 22 23 24 Standard Deviation 0.00% 25 Simba Sim 3b Sim 3c Sim 3d Sim se O Type here to search 99