Please show excel formulas, Thank you!

Soch Home Insert Page Layout Formulas W View Help X for D E A B State of the Economy Probability Recession 0.1 Below avg. 0.2 Average 0.4 Above avg. 0.2 Boom 0.1 Expected Return Standard Deviation Coefficient of Variation Beta T-Bills 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 0.0% 0.0 0.00 High Tech -29.5% -9.5% 12.5% 27.5% 42.5% 9.9% 20.0% 2.0 1.31 Collections 24.5% 10.5% -1.0% -5.0% -20.0% 1.2% 11.2% 9.8 -0.50 PART E Suppose you created a 2-stock portfolio by investing $50,000 in Hig E G H PARTE Suppose you created a 2-stock portfolio by investing $50,000 in High Tech and $50,000 in Collections. 1) Calculate the expected return, the standard deviation, and the coefficient of variation for this portfolio and fill in the appropriate blanks in the table above. veight in High Tech weight in Collections 50% 50% State of the economy Port, return Recession -2.5% Below average 0.5% Average 5.8% Above average 11.3% Boom 11.3% Portfolio return Port. std dev Port. CV Expected Portfolio Combinations: return Case model Soch Home Insert Page Layout Formulas W View Help X for D E A B State of the Economy Probability Recession 0.1 Below avg. 0.2 Average 0.4 Above avg. 0.2 Boom 0.1 Expected Return Standard Deviation Coefficient of Variation Beta T-Bills 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 0.0% 0.0 0.00 High Tech -29.5% -9.5% 12.5% 27.5% 42.5% 9.9% 20.0% 2.0 1.31 Collections 24.5% 10.5% -1.0% -5.0% -20.0% 1.2% 11.2% 9.8 -0.50 PART E Suppose you created a 2-stock portfolio by investing $50,000 in Hig E G H PARTE Suppose you created a 2-stock portfolio by investing $50,000 in High Tech and $50,000 in Collections. 1) Calculate the expected return, the standard deviation, and the coefficient of variation for this portfolio and fill in the appropriate blanks in the table above. veight in High Tech weight in Collections 50% 50% State of the economy Port, return Recession -2.5% Below average 0.5% Average 5.8% Above average 11.3% Boom 11.3% Portfolio return Port. std dev Port. CV Expected Portfolio Combinations: return Case model