MI4711 Data Analysis Laboratory – II Syllabus:

MI4711 Data Analysis Laboratory – II Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVE:

 The objective is to provide a hands-on knowledge of how to apply statistics to business situation in management functional areas using spreadsheets.

Exercise1: Portfolio selection
Exercise2: Exercise1 – Extension
Exercise3: Risk Analysis
Exercise4: Sensitivity Analysis using Monte Carlo simulation
Exercise5: Exercise4 – Extension
Exercise 6: Financial performance Analysis Using What if Analysis
Exercise7: Transportation problem
Exercise8: Exercise7 – Extension
Exercise9: Assignment problem
Exercise 10: Exercise9 – Extension
Exercise11: Shortest path Problem
Exercise 12: Maximum Flow Problem
Exercise13: Critical path Method
Exercise14: Queuing Model
Exercise15: Economic Ordering Quantity(EOQ)

COURSE OUTCOME:

TOTAL: 60 PERIODS

Develop and refine decision-making skills, upon the outcome of statistical tests. Analyze real world scenarios and determine the appropriate type of analytical problem solving technique for management functional areas.

REFERENCES:

1. David R. Anderson, et al, “An Introduction to Management Sciences: Quantitative approaches to Decision Making”, (13th edition) South-Western College Pub, 2011.
2. William J. Stevenson, Ceyhun Ozgur, “Introduction to Management Science with Spreadsheet”, Tata McGraw Hill, 2009.
3. Hansa Lysander Manohar, “DataAnalysis and Business Modelling using Microsoft Excel” PHI, 2017.
4. David M. Levine et al, “Statistics for Managers using MS Excel” (6th Edition) Pearson, 2010.