Data tables with one input variable

So far we've done some interesting what-if analysis; however, each analysis has relied on changing various inputs one at a time. There must be an easier way to analyze a range of input changes, right? Right! Data Tables are awesome for sensitivity analysis, which analyze ranges of input changes to understand how they impact the output.

Let's run a sensitivity analysis on how the Rent Growth % impacts net operating income.

If you have lost progress, close any open workbooks and load 2_2_goal_seek.xlsx from the Exercises folder.