|
|||||||||
The Sensitivity Analyzer add-in for Microsoft Excel performs "what if" analysis quickly and easily, and saves you a lot of time. It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013. The Sensitivity Analyzer add-in allows you to vary the data in up to five cells and return the values of up to 10 other cells. You can specify the starting, stopping, and step values for each of the five cells. It automatically creates a report containing the information on all the cases. It does the calculations and data processing far faster than you can manually, saving you time and eliminating the pain of doing many cases manually. And it puts the original data back in the worksheet cells when it is done processing the cases! It automatically creates a report containing the information on all the cases. The following dialog illustrates how you would specify input variables. Input variables are the ones that you want the Sensitivity Analyzer to vary.
Once you have completed the above panel the following panel appears to allow you to specify the output variables.
The following illustrates just part of the output using the above inputs and outputs:
Customers who viewed the Sensitivity Analyzer also viewed:
|
Order online |
||||||||
|
|||||||||