MI4511 Data Analysis Laboratory – I Syllabus:

MI4511 Data Analysis Laboratory – I 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 using spreadsheets.
Exercise 1 : Random number generation
Exercise 2 : Rank and percentile
Exercise 3 : Simple Random sampling and Systematic Random sampling
Exercise 4 : Descriptive Statistics
Exercise 5 : t-test
Exercise 6 : z-test
Exercise 7 : F-Test
Exercise 8: ANOVA
Exercise 9: Chi-square test
Exercise 10: Mann- Whitney U test
Exercise 11 : Kruskal-Wallis test
Exercise 12: Correlation and Regression
Exercise 13: One sample Run test
Exercise 14: Moving average and Exponential Smoothing
Exercise 15: Trend analysis

COURSE OUTCOMES :

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.

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, “Data Analysis and Business Modelling using Microsoft Excel” PHI, 2017.
4. David M. Levine et al, “Statistics for Managers using MS Excel” (6th Edition) Pearson, 2010.