Overview

 Basic sensitivity analysis is the simplest of the analyses in Sensitivity Explorer, that highlights how changes in one of the inputs in your model affect one of the outputs.

See the article Sensitivity Analysis Overview for more information about how Sensitivity Explorer analyses work, in general.

Choose Inputs and Outputs

Start by selecting a single input and output from your workbook model.  If you have previously used this workbook with Sensitivity Explorer, your input and output may already be shown in the lists.  If they are not yet there, click the input or output “Add” button to add the cells.  (See the article Working with Inputs and Outputs for more information.)

Run the Analysis

When you click the OK button, Sensitivity Explorer varies the input you selected across the range of values specified for it.  For each value, Excel recalculates your spreadsheet and records the output value.

Analyze the Results

After the analysis is complete, a result window is displayed.  Basic analysis results include two result views: Line Graph View, and Table View.  These are simply two ways of presenting the same underlying set of results.  The initial view displayed will depend on the menu item you chose from the ribbon when starting the analysis, but you can change the view by clicking the view buttons at the bottom of the window.

For more information about all the options in this window please see the article Working with Result Windows.

Line Graph View

The line graph view graphically displays the relationship between the output and input:

• This graph can be customized, copied to the clipboard, or exported to Excel by clicking the Actions icon at the bottom of the window.
• Clicking the Inspector icon at the bottom of the window will open a panel to the right of the graph where you can select and focus in on more detailed information about each point.

Table View

The table view shows all the input and output values in tabular format:

• The table can be customized, copied to the clipboard, or exported to Excel by clicking the Actions icon at the bottom of the window.