Question: Using a data table in Excel perform a sensitivity analysis

Using a data table in Excel, perform a sensitivity analysis on the example in Simple Decision Problem.xlsx. Specifically, keep the probabilities in row 10 (for D2) as they are, but vary the probability in cell C11 from 0 to 1 in increments of 0.05, and keep the probabilities in cells D11 and E11 in the same ratio as they are currently (2 to 3).

View Solution:

Sale on SolutionInn
  • CreatedApril 01, 2015
  • Files Included
Post your question