Close Menu

MAX 502 - Analytics for Decision Making

Course Description: 

Spreadsheets are a popular model-building environment for managers. Add-ins and enhancements to Excel have made powerful decision-making tools available to the manager. This course covers how to use the spreadsheet to develop and utilize some of these decision-making aids. Visual Basic for Excel allows the nonprogrammer to create modules for functions, subroutines, and procedures. Topics include forecasting (both regression and time series), decision-making under uncertainty and decision trees, using SOLVER for optimization, and probabilistic simulation using @RISK.

Credit: 

(3-0-3)

Prerequisite: 

None

Corequisite: 

None