IE 507: Modeling and Computation Lab


Introduction to software tools for modeling and data analysis Exposure to computational software for optimization. Use of some software tools such as AMPL/ CPLEX/ Spreadsheet Solver/ LINDO/ LINGO/ Neos Solver/ MATLAB for solving and analyzing optimization problems. Building models, representing input data, results, interpretation & sensitivity analysis.

Exposure to statistical packages for data analysis. Use of R/ SAS/ SPSS/ Excel-spreadsheet. Summarizing data with descriptive statistics, computing statistics, statistical estimation & tests

Notion of simulation and effect of randomness. Introduction to Monte Carlo simulation. Simulation of reliability, inventory, queueing systems and basic Markov models, computing performance measures.


  • Wayne L. Winston (2004) Data Analysis and Business Modeling with Microsoft Excel, Microsoft Press..
  • Robert Fourer, David M. Gay and Brian W. Kernighan (2003) AMPL: A Modeling Language for Mathematical Programming, 2nd edition, Duxbury Resource Center..
  • Sheldon M. Ross (2004) Introduction to Probability and Statistics for Engineers and Scientists, 3rd edition, Academic Press..
  • Jerry Banks, Barry L. Nelson and David Nicol (2004) Discrete Event System Simulation, 4th edition, Prentice Hall of India.