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. You can complete this exercise either on DataCamp using in-browser Excel (virtual machine) or locally in Microsoft Excel with Copilot. If you have lost progress, close any open workbooks and load 2_2_goal_seek.xlsx from the Exercises folder.