Sensitivity analysis is done in finance, operations, and even within the education sector. Watch Sensitivity Analysis – Microsoft Excel (4:22), which will introduce you to sensitivity analysis in Excel. Follow along with the formulas in the video using the Sensitivity Analysis Example spreadsheet linked below. It is very important to keep those formulas to obtain the correct answers!
After you watch the video, complete the Problem Set 7 assignment. If you have questions as you work through this problem set, go to the Problem Set 7 discussion topic to seek assistance from your peers and instructor. Data sets can be found in the DAT 520 Data Files folder in Start Here.
For additional details, please refer to the Problem Set 7 and the Advanced Problem Set Assignment Guidelines and Rubric PDF documents.
Comments