Solve problems using formulas- excel
5-Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in cells B9 and B10 (see Figure 9.4) to ensure that the probabili- ties of “fair” and “awful” remain in the same ratio, 35 to 20, and that all three probabilities continue to sum to 1. Then let the probability of “great” vary from 0.25 to 0.50 in increments […]