MBA 7025: Statistical Business Analysis

Course Schedule

Dr. Alok Srivastava

Visit this page regularly. I will be posting assignments, review materials, and other resources every week.

Home Datasets MBA in Business Analysis Six Sigma Certification

Session	Topics	Resources	Assignments (due following week)
1/12	Introduction Managerial Decision Making Information Technology Applications Current and Emerging Trends Data and Business Decisions (ch. 1)	Publishing to the Web Go over Excel Tutorial in eTraining (if necessary)	Personal Statement and Summary of Chapter 1
Objectives	Visualizing and Describing Data
1/19	Ch. 2. Displaying Data: Charts and Graphs 2.3 Frequency Distributions (Example) 2.4 Scatter Diagrams (Example) 2.5 Line Charts (Example 1, Example 2) 2.6 Pie Charts (Example) 2.6 Column and Bar Charts (Example) Spreadsheets for Examples	Tutorial on Charts and Graphs Online Stats Textbook	Project 1a: Charts and Graphs Tutorial on Pivot Tables
1/26, 2/2	Ch. 3. Summarizing Data: Descriptive Statistics 3.2 Central Tendency (Ex. 3.1, Ex.3.2) 3.3 Quartiles and Percentiles 3.4 Maximum, Minimum and Range 3.5 Measures of Dispersion (Ex.3.3, Ex.3.4) 3.6 Descriptive Summary Measures (Ex. 3.5) 3.7 Statistical Relationships (Ex. 3.6)	Using Excel Functions Spreadsheets for Ch 3 Examples	Project 1b: Descriptive Statistics
2/9	Ch. 9 Confidence Interval Estimation Sampling Distribution of the Sample Mean The Central Limit Theorem Confidence Interval for a Mean Confidence Interval for a Total Confidence Interval for a Proportion	Template for Confidence Intervals Examples
2/16	Ch. 10 Hypothesis Testing Types of Errors Significance Level and Rejection Region Significance from p-values Hypothesis Tests and Confidence Intervals Practical Versus Statistical Significance Hypothesis Tests for a Population Mean One-Way ANOVA	Examples	Project 2: Hypothesis Testing and Confidence Intervals
2/23	Ch. 10 Hypothesis Testing Continued
3/2	Midterm Exam		Test Bank
Objectives	Modeling Relationships
3/16	Ch. 11. Regression Analysis 11.2 Scatterplots 11.3 Correlations 11.4 Simple Linear Regression (Ex.11.1a, Ex. 11.2a)	Interpreting Regression Results Datasets for ch.11	Project 3: Regression Models
3/23	Ch. 12 Multiple Regression 11.5 Multiple Regression (Ex. 11.2b) 12.3 Inferences About Coefficients (Ex.12.1) 12.4 Multicollinearity (Ex.12.2) 12.5 Include/Exclude Decisions (Ex. 12.3) 12.11 Prediction	Datasets for ch.12
Objectives	Decision Support Systems
3/30	Decision Support Systems – a tour The Modeling Process Modeling Firm Demand Marketing Models Manufacturing Models Financial Models	DSS for marketing decisions	Project 4: A Case for Modeling Demand Data for Demand Model
4/6	Decision Support Systems Model Implementation and Use Sensitivity Analyses Goal Seeking Scenario Analyses
4/13	14: Optimization Modeling Linear Programming Graphical Solution Using Solver Product Mix Models	Examples – Excel file	Other Examples
4/20	Business Intelligence Data Warehousing and Marts Corporate Dashboards Corporate Performance Management		Video: Introduction to Microsoft Business Intelligence
4/27	Application Project Presentations		Application Project (Examples)
5/4	Final Exam		A Case for Modeling Demand (Bring results to class for the final exam)
	Misc (Patch to upgrade software that accompanies the text)

Online Stats Texts/Resources