Abstract
Net-Present-Value of profit for a new product varies as several uncertain inputs vary. The model on the next sheet is the same. The advanced sensitivity analysis shows the mean of output varies for different values of an uncertain or fixed input. Select ‘advanced sensitivity analysis' from the advanced analyses dropdown. This opens a dialog where one can select an output to monitor and add inputs to vary. They can add uncertain inputs, or add fixed inputs, such as the discount rate. The have several options on how each input is varied, and can change various options via the options button. They can open the advanced sensitivity analysis dialog to see the settings that were used and click the ‘analyze' button to run the analysis. @RISK runs many simulations. Each simulation has one fixed input at one of the values in its range, but otherwise, the simulation is run in the usual way.
Reference6 articles.
1. BlokdykG. (2021). Sensitivity analysis The Ultimate Step-By-Step Guide. SIAM.
2. Borgonovo, E. (2017). Sensitivity Analysis: An Introduction for the Management Scientist (1st ed.). Springer.
3. Basics and Trends in Sensitivity Analysis
4. Saltelli, A. (2004). Sensitivity Analysis in Practice: A Guide to Assessing Scientific Models 1st Edition, Wiley.
5. Saltelli, A. 2008. Sensitivity Analysis in Practice: A Guide to Assessing Scientific Models (1st ed.). Wiley.