Insert a one- or two- variable sensitivity table - Next generation tools for Microsoft Office
  1. Ampler.io
  2. Resources
  3. Excel tutorials
  4. Insert for Excel
  5. Insert a one- or two- variable sensitivity table

Insert a one- or two- variable sensitivity table

  • Quickly perform a sensitivity analysis for your model output
  • Test one input variable against multiple model outputs
  • Test two input variables against one model output

 

  1. Click on ‘Sensitivity Table‘ and select either one or two variables
  2. Add model output cell references and model variables (input)
  3. Set the sensitivity range and number of steps. Select output cell and click OK
Was this article helpful?

Related Articles

Try free