Please help me solve!

Conduct a sensitivity analysis using Excel's Data Table, with sumlar columns to the ones we developed in class:

-First column: Prob of Recession with values ranging from 0 to 1 by .1 increments

-Second column: Optimal Decision

-Third Column: Expected Value

Assume there is a 40 os chance of recession next yeat, Considering the following investment alternatives and their projected returns for 2023 under recession and no recession if you invest $100 today. Assume you have to invest your $100 in one imestment altemative only. Use the Expected Value (Byyes) method to determine the optimal investment decialon. EV 37.4 Optimal Dee: Vertex Phamaceutcals ine (Growh Stock) point Conoxt a sersitivity andysis is ing Erceen Dats Tatie, with similar columns to the ones we developed in ciass: Fivi colum. Prob of Recession weth values irring from 01016by, t increments - Secons column optima Decision -Third column Expecied Value Pixce Seretivity Table inaide the yelow avea below 00 fx Enter text or formula here =0[] Assume there is a 40 os chance of recession next yeat, Considering the following investment alternatives and their projected returns for 2023 under recession and no recession if you invest $100 today. Assume you have to invest your $100 in one imestment altemative only. Use the Expected Value (Byyes) method to determine the optimal investment decialon. EV 37.4 Optimal Dee: Vertex Phamaceutcals ine (Growh Stock) point Conoxt a sersitivity andysis is ing Erceen Dats Tatie, with similar columns to the ones we developed in ciass: Fivi colum. Prob of Recession weth values irring from 01016by, t increments - Secons column optima Decision -Third column Expecied Value Pixce Seretivity Table inaide the yelow avea below 00 fx Enter text or formula here =0[]