Business Analytics Course Calendar

January 17

Do this Pre-Course Assignment Course (after getting my "Welcome" email).

Introduction and Overview

Chapter 1: What is Statistics, Read entire chapter.
Chapter 2: Graphic Presentation, Read entire chapter.
Chapter 3: Numerical Measures, Read entire chapter.
Chapter 4: Exploring Data, Read chapter, skip Stem-and-Leaf Displays, and Contingency Tables

Course Objectives:
CO1 - Categorize data to construct appropriate tables and charts, and interpret data using Excel.

January 23

Decision Analysis and Decision Trees. Supplemental Readings: Lind Ch20 (from 18 Ed.) (PDF), Bertsimas Ch.1 §1-3 (PDF)

Tableau (Optional): Getting Started

Course Objectives:
CO2 - Investigate decision alternatives in the face of uncertainty. To use decision tree diagrams.
CO7 - Determine the best decision using optimization techniques and models in Excel.

January 31

Chapter 5: Probability Concepts, and Counting. Read chapter, skip Contingency Tables, and Baye's Theorem.

Tableau (Optional): Replication of M&M Charts

Course Objectives:
CO3 - Define probability for an event and calculate probabilities and outcomes using rules of addition, multiplication, and counting.

February 7

Chapter 6: Discrete Probability Distributions. Read chapter, skip Hypergeometric and Poisson Probability Distributions.

Tableau (Optional): Box Plots

Course Objectives:
CO4 - Distinguish different kinds of probability distributions. To calculate probabilities of events using Excel.

February 14

Chapter 7: Continuous Probability Distributions. Read chapter, skip Normal Approximation to the Binomial (17th. ed. and earlier,) and The Family of Exponential Distributions (18th ed.)

Tableau (Optional): Non-Excel visualizations

Course Objectives:
CO4 - Distinguish different kinds of probability distributions. To calculate probabilities of events using Excel.

February 21

Chapter 8: Sampling Methods. Read entire chapter.

Chapter 9: Estimating the Population Mean, and Confidence Intervals. Read chapter. Skip Confidence Level for a Proportion.

Tableau (Optional): Clustered Charts

Course Objectives:
CO4 - Distinguish different kinds of probability distributions. To calculate probabilities of events using Excel.
CO5 - Calculate probabilities and p-values to evaluate hypotheses about sample data to support decisions using Excel

Exam 1, Weeks 1-5. This exam will be administered "online." It is available from 2/19 to 2/25. Let Dr. Jerz know if you need it a little earlier or later.

February 28

Chapter 10: One-Sample Tests. Read chapter, skip Tests Concerning Proportions, Type II Error.
Chapter 11: Two-Sample Tests. Read chapter. Skip Two-Sample Tests about Proportions (In the 15th edition and earlier textbook editions.)
Chapter 12: ANOVA, Chapter 12: Read from chapter beginning up to and including The ANOVA Test.

Tableau (Optional): Cleaning data and working with named ranges

Course Objectives:
CO4 - Distinguish different kinds of probability distributions. To calculate probabilities of events using Excel.
CO5 - Calculate probabilities and p-values to evaluate hypotheses about sample data to support decisions using Excel

March 7

Chapter 13: Simple Linear Regression and Correlation. Read chapter, skip Transforming Data.

Tableau (Optional): Scatter Diagrams

Course Objectives:
CO6 - Calculate relationships between two or more sets of data using regression analysis in Excel

March 21

Chapter 14: Multiple Regression. Read chapter, skip Stepwise Regression.

Tableau (Optional): Regression Analysis

Course Objectives:
CO6 - Calculate relationships between two or more sets of data using regression analysis in Excel

March 28

Optimizations and Simulation. Supplemental Readings: Stevenson Chapter 19 Linear Programming (PDF), Bertsimas Chapter 5 Simulation Modeling (PDF), and Transportation Models (PDF - Heizer).

Tableau (Optional): Multiple Regression Analysis

Course Objectives:
CO7 - Determine the best decision using optimization techniques and models in Excel
CO8 - Use simulation modeling techniques in Excel to evaluate uncertain business environments
CO2 - Investigate decision alternatives in the face of uncertainty. To use decision tree diagrams.
CO3 - Define probability for an event and calculate probabilities and outcomes using rules of addition, multiplication, and counting
CO4 - Distinguish different kinds of probability distributions. To calculate probabilities of events using Excel.

April 4

Exam 2, Weeks 6-10. This exam will be administered "online." The exam will be available from 4/2 to 4/8.
Semester ends. All remaining work due by Friday, April 8, 11:55 PM.

Tableau (Optional): Sharing Your Visualizations