Show all work in excel with formulas

9. You anticipate four possible economic scenarios across a holding period during which you invest in Tesla (TSLA) stock. The following table shows probabilities of the scenarios, as well as the projected return on the stock for each scenario. (a) Calculate the expected holding-period return for TSLA stock. (b) Calculate the standard deviation of returns surrounding TSLA stock's expected return. (Each part is worth 2.5 points) Return on Tesla Probability Return on Tesla Probability Scenario Excellent Scenario 20% 14.70% Fair 30% 3.00% Good 40% 7.50% 10% -8.40% or 9. You anticipate four possible economic scenarios across a holding period during which you invest in Tesla (TSLA) stock. The following table shows probabilities of the scenarios, as well as the projected return on the stock for each scenario. (a) Calculate the expected holding-period return for TSLA stock. (b) Calculate the standard deviation of returns surrounding TSLA stock's expected return. (Each part is worth 2.5 points) Return on Tesla Probability Return on Tesla Probability Scenario Excellent Scenario 20% 14.70% Fair 30% 3.00% Good 40% 7.50% 10% -8.40% or