An output comparison analysis is used to analyze how a single input affects multiple 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 multiple outputs (a maximum of ten) from your workbook model.  If you have previously used this workbook with Sensitivity Explorer, your inputs and outputs 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 all the output values.

Analyze the Results

After the analysis is complete, a result window is displayed.  Output Comparison analysis results include two result views: Spider 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.

Spider Graph View

The spider graph view displays, in detail, how the input affects the outputs.  Since the outputs, in general, will have different scales and units, they are plotted in terms of relative change from their base-values.   This allows them to be plotted on a single graph, and for easy comparisons to be made between them.

• 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 on more detailed information.

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.