Excel Sensitivity Analysis
Rate this solution:(2.3/5 from 3 votes)
|Sensitivity Analysis for Excel is a powerful and simple to use tool for performing sensitivity analysis on Excel models. Results can be obtained through three possibilities: tornado analysis, spider analysis and sensitivity tables. |
Key features of Sensitivity Analysis for Excel include:
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 representation of the changes produced in the target optimal solution or function whenever a specific quantity or value in a model’s parameters changes in a constant proportion.
This type of analysis makes it possible to make variations (by percentages) in the same amounts for all input variables.
Tables showing constant variations of each input variable (defined variations with a base value, an increase value and a ceiling) and the effect of such changes to changes to output variables.
(Pricing is available on the next page)
(Updated on 2020-03-01)
Related Excel Solutions for Sensitivity AnalysisMonte Carlo Analysis Add-inRisk Analysis Decision Impact AnalysisRisk Analysis What If AnalysisRisk Analysis Monte Carlo SimulationRisk Analysis Risk SimulationRisk Analysis Input Cell SolverNavigation and Auditing
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity