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...

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).

=RISKDISCRETE (B11:B14, C11:C14)

=D11/(1 $B$5)^(A11–0.5)

=SUM(E9:E11)