What … If, is a method for performing a sensitivity Analysis, base on the questions What would be the outputs if the inputs of the model assume different values. This type of analysis, use existing input data for estimate outputs data points, this will give you a range of probable outcomes. This approahc is really helpfull when when data is limited.
What ….IF is based on:
- Quantify the uncertainty in each input (e.g. ranges, probability distributions).
- Identify behavior of the output when input is varied.
- Run the model a number of times and using the resulting model outputs to calculate the sensitivity of the output related to the input varied.
What..If helps to identify critical assumptions for your analysis or compare alternative model structures. So is a versatil tool for any business analyst toolbox.