Sensitivity Analysis

This chapter focuses on the standard techniques of sensitivity analysis using Excel data tables. These techniques are useful on their own. They also are critically important in the rest of the book. Data tables bring a looping capability to Excel. This capability can be used to control input variables in a manner core to many analytics methods within native Excel.