Moodle, Syllabus

 

Week #

Date

Assignment

1

Aug 26

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 chapter, skip Geometric Mean.
Chapter 4: Exploring Data, Read chapter, skip Stem-and-Leaf Displays, and Contingency Tables

Tableau (Optional): What is Tableau? Access and installation.

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

2

Sept 2

Decision Analysis and Decision Trees. Supplemental Readings: Lind Ch20 (from 16 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.

3

Sept 9

Chapter 5: Probability, 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.

4

Sept 16

Chapter 6: Discrete 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.

5

Sept 23

Chapter 7: Continuous Distributions, Read chapter, skip Normal Approximation to the Binomial, and The Family of Exponential Distributions.

Tableau (Optional): Non-Excel visualizations

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

6

Sept 30

Chapter 8: Sampling Methods, Read entire chapter.

Chapter 9: Estimations and Confidence Intervals. Read chapter. Skip Confidence Level for a Proportion, and Finite-Population Correction Factor.

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

6

 

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

7

Oct 7

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, Two-Sample Tests of Hypothesis: Dependent Samples, and Comparing Dependent and Independent Samples.
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

8

Oct 14

Chapter 13: 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

9

Oct 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

10

Oct 28

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

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.

11

Nov 4

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

Tableau (Optional): Sharing Your Visualizations