Sensitivity Analysis with Excel Solver

In this article you’ll get to know about Sensitivity Analysis in Excel. Sensitivity Analysis is a report which shows all the possible probabilities of the solution for a problem.

After you solve the problem, the Solver Results dialog box will open up. To get the Sensitivity Analysis click on Sensitivity in the Reports section.

Sensitivity Analysis in Excel

Let’s look at a problem, its aim is to maximize the flow. Solve it as how you will usually solve a problem using Solver tool in Excel.

Sensitivity Analysis with Excel Solver

After you solve the problem, the Solver Results dialog box opens up. To get the Sensitivity Analysis select the Sensitivity option under Reports and click on OK.

Sensitivity Analysis with Excel Solver

The Analysis gets displayed in an new worksheet.

Sensitivity Analysis with Excel Solver

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021