Tag: data table
-
Two-way Data Table in Excel is a great tool for sensitivity analysis
In an earlier post, I have introduced Data Table as a “secret weapon” to conduct sensitivity analysis. Now let’s go one step further and look at a more advanced type of Data Table called Two-way Data Table. As the name suggests, it offers a way to study the joint effect of TWO variable on the…
-
Data Table is a Secret Weapon in Excel Modeling and Analysis
Scenario analysis (also called What-ifs) is an indispensable part of business decision models. What is demand is only half of predicted? What if conversion rate is 50% higher? What if we drop our inventory by 1000 units? Once a decision model is built, it helps decision makers to test outcomes under various scenarios. Excel provides…