Data and Business Analytics

Engr 213 Data and Business Analytics (Instructor: Huang, B.) Lecture, four hours; outside study, eight hours. Coverage of wide variety of spreadsheet models that can be used to solve business and engineering problems, with emphasis on mastery of Excel spreadsheet modeling as integral part of analytic decision making. Managerial models include data modeling, regression and forecasting, linear programming, network and distribution models, integer programming, nonlinear programming, and Monte Carlo simulation. Problems from operations, finance, and marketing taught by spreadsheet examples and describe general managerial situations from various industries and disciplines. Development of spreadsheet models to facilitate decision making. Letter grading.