Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 18. Using the Scenario Manager for sensitivity analysis

Question answered in this chapter:

• I’d like to create best, worst, and most likely scenarios for a firm’s sales of an automobile model by varying the values of Year 1 sales, annual sales growth, and Year 1 sales price. Data tables for sensitivity analysis enable me to vary only one or two inputs, so I can’t use a data table. Does Excel have a tool I can use to vary more than two inputs in a sensitivity analysis?

You can use the Scenario Manager to perform sensitivity analysis by varying as many as 32 input cells. With the Scenario Manager, you first define the set of input cells you want to vary. Name your scenario and enter the value of each input cell for each scenario. Finally, select ...