The Sensitivity Analysis Tool extends Excel by allowing quick and easy generation and graphing of data sets for a virtually unlimited range of functions.
Sensitivity analysis is the process of observing how an output varies over a range of inputs. Entering these inputs manually can be a tedious and error-prone activity. The Sensitivity Analysis Tool greatly simplifies this task. Simply enter the desired range of values, indicate the input and output cells and hit a button. The Sensitivity Analysis Tool will iterate over the given values and produce a data set containing the output for each value. It will then create a graph so you can see at a glance how varying the input values affects the value of the output.