DATA ANALYSIS AND BUSINESS MODELING- PRACTICAL SYLLABUS

AFFILIATED INSTITUTIONS
ANNA UNIVERSITY: : CHENNAI 600 025

REGULATIONS - 2013

MASTER OF BUSINESS ADMINISTRATION (MBA)

BA7211	DATA ANALYSIS AND BUSINESS MODELING	LT P C
COURSE OBJECTIVE		0 0 4 2

to have hands- on experience on decision modeling

COURSE OUTCOME

Knowledge of spreadsheets and data analysis software for business modeling [Business models studied in theory to be practiced using Spreadsheet / Analysis Software]

S.No.	Exp. No.	Details of experiments	Duration
		Name
1	1	Descriptive Statistics	4
2	2	Hypothesis - Parametric	4
3	3	Hypothesis – Non-parametric	4
4	4	Correlation & Regression	4
5	5	Forecasting	4
6	-	Extended experiment – 1	4
7	6	Portfolio Selection	4
8	7	Risk Analysis & Sensitivity Analysis	4
9	8	Revenue Management	4
10	-	Extended experiment – 2	4
11	9	Transportation & Assignment	4
12	10	Networking Models	4
13	11	Queuing Theory	4
14	12	Inventory Models	4
15	-	Extended experiments – 3	4

TOTAL: 60 PERIODS

REQUIREMENTS for a batch of 30 students

1.    Personal Computers – 30 nos

2.    Any licensed Spreadsheet and Analysis software like Microsoft Excel, SPSS etc– 30 user licenses

23

TEXT BOOKS

1.    David M. Levine et al, “Statistics for Managers using MS Excel’ (6^th Edition) Pearson, 2010

2.    David R. Anderson, et al, ‘An Introduction to Management Sciences: Quantitative approaches to Decision Making, (13^th edition) South-Western College Pub, 2011.

3.    William J. Stevenson, Ceyhun Ozgur, ‘Introduction to Management Science with Spreadsheet’, Tata McGraw Hill, 2009.

4.    Wayne L. Winston, Microsoft Excel 2010: Data Analysis & Business Modeling, 3^rd edition, Microsoft Press, 2011.

5.    Vikas Gupta, Comdex Business Accounting with Ms Excel, 2010 and Tally ERP 9.0 Course Kit, Wiley India, 2012

6.    Kiran Pandya and Smriti Bulsari, SPSS in simple steps, Dreamtech, 2011. 




EXPERIMENT NO 1:

manual:
https://drive.google.com/file/d/0B3CnefCXrk8lOGxoWVFaRHJyU0k/view


Excel Tool pak - working steps
https://drive.google.com/file/d/0B3CnefCXrk8lU0ktWGxpUVRPanM/view

Descriptive_Statistics_in_Excel- working steps.
https://drive.google.com/file/d/0B3CnefCXrk8lSFlLOURPVXVtcFk/view