Sensitivity Analysis in Excel - Exploring the Parameter Space

Sensitivity Analysis in Excel Part of the lecture series "Exploring the Parameter Space": https://nickderobertis.github.io/fin-... Full Course Website: https://nickderobertis.github.io/fin-... Notes -------- Data tables in Excel allow calculating a cell multiple times, changing some other cell. This is perfect for sensitivity analysis if we target an output cell and change an input cell One-way data tables change one input at a time, two-way data tables change two inputs at a time You are basically limited to changing two inputs at once, without doing some clever hacks Visualization rule of thumb: graph one-way data tables and use conditional formatting for two-way Conditional formatting changes the format of cells based on conditions, such as putting the largest numbers in green and the smallest in red Row input cell means that your inputs are going horizontally in a row. Column input cell means that your inputs going vertically in a column. For one-way data tables, you will use only one of the two. For two-way data tables, you will use both Resources ------------ Dynamic Salary Retirement Model - Excel: https://nickderobertis.github.io/fin-...