In simple terms, it helps determine what effect does changing the two variables have on the result. We have two kinds of data tables here вЂњOne variable data tableвЂќ and вЂњ Two-variable data table Two-variable Data Table A two-variable data table helps analyze how two different variables impact the overall data table. The data table can create different scenario tables based on the change of variable. We have already seen two wonderful techniques under What-If Analysis in Excel. In order to get an overall average of 85, Andrew has to score 99 in the final exam. Excel will take a few seconds to complete the process, but eventually, it shows the end result like the below one. So we need to change the cell B6, which is the cell for the final subjectвЂ™s score. The next and final part is by changing which cell you want to see the impact. This is nothing but for what value we need to set the cell, i.e., AndrewвЂ™s overall average GOAL (85). Set Cell is nothing but which cell we need the final result, i.e., our overall average cell (B7). Step 3: Here, we need to set the cell first.Step 2: It will show you below the dialog box.Step 1: Go to DATA > What-If Analysis > Goal Seek.This can find out by what-if analysis GOAL SEEK tool. Now the question is how much he has to score in the final exam to get an overall average of 85 eventually. In order to calculate the current average, apply the Average formula in B7 cell.ДЄndrewвЂ™s GOAL is 85, and his current average is 82.2 and short by 3.8, with one exam to go. In the completed 5 exams, the anticipated scores are as below.

His target is to achieve an average score of 85 in the final exam, and he has already completed 5 exams and left with only 1 exam. What-if Analysis Goal can tell you what you have to do to achieve the set target.ДЄndrew is a class 10 th student. Now we know the scenario managerвЂ™s advantage. Total excel has created 3 scenarios even though we have supplied only 2 scenario changes because excel will show existing reports as one scenario.ДЇrom this table, we can easily see the impact of changes in pour profit %. It will create a summary report for you in the new worksheet. Here we need to change the Total Expense Cell (C12), Total Profit Cell (C14), and Profit % cell (C16).

Click on SUMMARY it will ask you which result cells you want to change.

It will show all the scenarios we have created.

This time we need to change Project cost (C10), Labour Cost (C8), and Operating Cost (C9) As we listed in scenario 2, make the changes. Now, it will ask you to create one more scenario.Do not click on OK but click on OK Add.It will ask you to mention the new values, mention new values as listed in scenario 1.

The changes are Project cost (cell C10) at 15 million, Raw material cost (cell C7) at 11 million, and other expenses (cell C11) at 4.5 million.

In changing cells, select the first scenario changes you have listed out.

Once you click on Scenario Manager, it will show you below the dialogue box.

Go to DATA > What-If Analysis > Scenario Manager.

In order to create what-if analysis scenarios, follow the below steps.

Data analysis excel template