 |
|
|
Special! Buy The Excel Sensitivity Analyzer and Get a Free Choice of Complete Excel Training Course OR Excel Add-ins Collection. Buy more than 1 License and get BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
What if Analysis Manager is a tool which is powerful and simple to use, since, with What if Analysis Manager you will be able to perform sensitivity analyses on your Microsoft® Excel® models, obtaining results through three possibilities: tornado analysis, spider analysis and sensitivity tables.
Important characteristics
- Affords a Wizard which is intuitive and easy to use.
- 100% integrated with Microsoft® Excel®.
- Intuitive and easy interpret reports.
- Access to sensitivity models for quick updating and results viewing.
- Automatic detection of input data.
- Automatic detection of variables’ headings.
- The market’s most robust tool at the lowest price.
What is a sensitivity analysis (what if analysis)
Sensitivity Analysis (or Post-Optimization Analysis) studies the manner how the most optimal target solution or function (Output), would be affected by changes in the value of one or more parameters (Input) of a model, while the rest of them remain unchanged.
These charts show a graphical depiction of the changes produced
in the target optimal solution or function whenever a specific
quantity or value in your model’s parameters changes in a
constant proportion. The Tornado Chart tells us that the greater the corresponding
bar in the tornado chart, the greater the sensitivity and
importance of that parameter to generate output.
 |
This type of analysis makes it possible to make variations, by percentages, in the same amounts for all input variables. The more inclined a parameter’s line is to the horizontal line, the more significant the change in the value of the target optimal solution or function is whenever the parameter’s value changes.
 |
It shows tables with constant variations of each input variable (variations which you define - with a base value, an increase value and a ceiling) and the effect of such changes in changes to output variables.
 |
What if Analysis Manager is your best partner when developing a “WHAT-IF ANALYSIS”; process involving changes in the values of input cells, to see how they would affect the spreadsheet’s output (cells containing formulas).
What-if Analysis Manager is TOTALLY COMPATIBLE WITH EXCEL 97-2007 and WINDOWS 95-VISTA!!!
What-if Analysis Manager 
Special!
Buy The Excel Sensitivity Analyzer and Get a
Free Choice of
Complete Excel Training Course
OR
Excel Add-ins Collection.
Buy more than 1 License and get BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
| Pricing: |
|
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
See Also: Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
FREE Excel Help