Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Sensitivity Analysis—One-and Two-Way Data Tables
FIGURE 17.2 Preparing the Data Table
Transfer the Parameters to the Table
FIGURE 17.3 Preparing the Data Table
FIGURE 17.4 Creating a One-Way Data Table
The data table can then be filled with the desired sensitivity analysis results. The
first step is to select the area of the table where the results should appear (E2:H9).
The second step is to activate the Data Table menu item. Under the Data Ribbon,
on the drop-down menu of the What-If Analysis, choose Data Table. See Figure 17.4.
(In Excel 2003 or earlier, use Data menu
In the data table dialog box, on the right side of Figure 17.5, select the Column
input cell (remember, the input data
the Rate, is changing down the column) and
click on cell B5
the cell containing the original rate. Click OK.