Optimization using Excel – 6.Sensitivity analysis

Video
Optimization using Excel
Lecture 6
Soumitra Chakraborty

This is the sixth video of the lecture series Optimization using Excel. This is video is the explanation of all the parts of an answer report and sensitivity report generated from Excel’s Solver add-in. Viewers are advised to watch the prior videos in the same lecture series “Optimization using Excel” in order to feel the continuity. An answer report is the vivid description of the model output while the sensitivity report is the prediction of the model output when the model parameters change within a certain range.