$\backslash$table$[[$Goal Seeking Analysis,Sensitivity Analysis$],[$What$-$If Analysis,Optimization Analysis$]]$

Checks the impact of a change in a variable or assumption on the model

Finds the inputs necessary to achieve a goal such as a desired level of output

The study of the impact on other variables when one variable is changed repeatedly

Finds the optimum value for a target variable by repeatedly changing other variables, subject to specified constraints.

Reset