For the decision problem in Figure 6.1, use data tables toperform the following sensitivity analyses. The goal in each is tosee whether decision 1 continues to have the largest EMV. In eachpart, provide a brief explanation of the results.
a. Let the payoff from the best outcome, the value in cell A3,vary from $30,000 to $50,000 in increments of $2500.
b. Let the probability of the worst outcome for the firstdecision, the value in cell B5, vary from 0.7 to 0.9 in incrementsof 0.025, and use formulas in cells B3 and B4 to ensure that theyremain in the ratio 1 to 2 and the three probabilities for decision1 continue to sum to 1.
c. Use a two-way data table to let the inputs in parts a and bvary simultaneously over the indicated ranges.
Please provide solution as per Excel.
| Decision 1 | | | Decision 2 | | | Decision 3 | |
| Payoff/Cost | Probability | | Payoff/Cost | Probability | | Payoff/Cost | Probability |
| $50,000 | 0.1 | | $5,000 | 0.6 | | $3,000 | 1 |
| $10,000 | 0.2 | | -$1,000 | 0.4 | | | |
| -$5,000 | 0.7 | | | | | | |
| | | | | | | |
| EMV | | | EMV | | | EMV | |
| | | | | | | |
| | | | | | | |
