Moodle, Syllabus

 

Week #

Date

Assignment

  Before Course Begins

Pre-Course Assignment
Course Introduction and Overview

1

January 14

Introduction and Overview

Chapter 1: What is Statistics, Read entire chapter.
Excel: Some Basics of MS Excel

2

January 21

Chapter 2: Graphic Presentation, Read entire chapter.
Excel: Creating Graphs in Excel

3

January 28

Chapter 3: Numerical Measures, Read chapter, skip Geometric Mean.
Excel: Descriptive Statistics using the Excel models

4

February 4

Chapter 4: Exploring Data, Read chapter, skip Stem-and-Leaf Displays, and Contingency Tables
Excel: Creating Distributions from Data, Analyzing Grouped Data, Working with Tables, and PivotTable

5

February 11

Data Preparation
Supplemental Reading: Importing Data.
Excel: Following the step-by-step instructions, complete the steps and submit your Excel file.

6

February 18

Chapter 15: Nonparametric Methods: Nominal Level Hypothesis Test
Read Goodness-of-Fit Tests: Comparing Observed and Expected Frequency Distributions, Limitations of Chi-Square, Testing the Hypothesis that a Distribution is Normal
Excel: Testing frequency shapes using the Chi-Square Excel model

7

February 25

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.
Excel: Testing two samples using the Excel Two-Sample model

8

March 4

Presentation Preparation

Exam1

9

March 11

Chapter 13: Regression and Correlation, Read chapter, skip Transforming Data.
Excel: Linear regression using the Excel Linear Regression model

 

March 18

Spring Break, no class

10

March 25

Chapter 14: Multiple Regression, Read chapter, skip Stepwise Regression.
Excel: Multiple regression using the Excel Multiple Regression model

11

April 1

Chapter 18: Forecasting, Read entire chapter.
Excel: Forecasting techniques using the Excel Forecasting models

12

April 8

Tableau Basics
Readings: None
Refer to the Resources and Activities web page for this week.

13

April 15

Tableau II
Readings: None
Refer to the Resources and Activities web page for this week.

14

April 22

User-Defined Functions and VBA, PivotTables and Slicers, and Regression in Tableau
Readings: PivotTables_PivotCharts_Slicers, for the second part of these assignments.

15

April 29

Project Presentations Due

Project Discussions

16

May 6-10

Exam2