The process of determining the effects on outcomes in a statistical model or spreadsheet calculation through systematic changes in the input. For example, in the budgeting process, many factors, such as future tax rates, interest rates, inflation rates, employee count, expenses, are variable to the extent that they can deviate from expected values. Also called sensitivity analysis.
Related information about what-if analysis:
- Introduction to what-if analysis - Excel - Office.com
By using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results.
- Excel 2010: Using What-If Analysis - Lesson 21
The real power in Excel comes in its ability to perform multiple mathematical calculations for you. One of the tools in Excel that you can use to perform these ...
- What If Analysis
TECH 482/535. What if Analysis. Summary of What-if Analysis. What-if analysis is a brainstorming approach that uses broad, loosely structured questioning to: ...
- Excel 2010: What If Analysis - YouTube
Feb 28, 2011 ... http://www.gcflearnfree.org/excel2010 The real power in Excel comes in its ability to perform multiple mathematical calculations for you. One of ...
- How to Use Excel's What-If Analysis
Apr 11, 2010 ... One often overlooked feature of Excel is the What-If Analysis that allows you to explore different scenarios without changing the values in your ...
- What If - Wikipedia, the free encyclopedia
What-if analysis, or sensitivity analysis, the study of how model output varies with changes in input; What if chart, a visual tool for modeling the outcome of a ...
- Sensitivity analysis - Wikipedia, the free encyclopedia
Sensitivity analysis is the study of how the uncertainty in the output of a mathematical model or system (numerical or otherwise) can be apportioned to different ...
- The power of what if analysis - The Performance Ideas Blog
Feb 23, 2012 ... What if analysis is a very powerful but underutilized tool. This post provides a few ideas that every business person should consider.