Microsoft Office Tutorials and References
In Depth Information
Exhibit 7.12 One-variable data table
What-If Analysis. This step utilizes a wizard that requests the location of the Row
input cell and Column input cell. See Exhibit 7.14. In the case of the one variable
table, in vertical orientation, the relevant choice is the Column input cell because our
variable values appear in column M. This wizard input identiļ¬es where the variable
is located that will be used by the formula. For the one-variable table, the wizard
input is cell C13; it has a current value of $50. In essence, the Data Table is being
told where to make the changes in the formula. In Exhibit 7.15 we see the two-
variable Data Table with Row input cell as C3 and Column input cell as C13, the
cell location of the formula input for Entry Fee and Bets , respectively. The results for
both the one-variable and the two-variable Data Table are shown in the previously
introduced Exhibit 7.11.
Of course in more complex problems, the possible combination of variables for
sensitivity analysis could be numerous. Even in our simple problem, there are 8
possible variables that we can examine individually or in combination (2, 3, 4,
and 8 at a time); thus, there are literally thousands of possible sensitivity analysis
scenarios we can study.
Search JabSto ::

Custom Search