Information for Sharpe, DeVeaux & Velleman statistics text (second edition, 2012)
Page last updated September 8, 2014
Dr. Robert L. Andrews, Instructor SCMA 524 SCMA 301 SCMA 302

Notes for Chapters 1, 2 & 3 (Excel document)

Process Study Procedures from Melton (Flow Chart, Cause & Effect Diagram, Determining Process Stability) (Excel document)

Simulation Demonstration: Run Chart for determining process stability(Excel document)

Frequencies & Graphs using Excel for Chapters 4 & 5 (Excel document)

Descriptive Measures, Chapters 4 & 5 (Excel document)

2 Quantitative Variable Relationships, Chapter 6 ( 97-2003 Excel file for X-Y Scatter, Correlation & Regression)
2 Quantitative Variable Relationships, Chapter 6 ( 2007-2013 Excel file for X-Y Scatter, Correlation & Regression)

Notes for Chapters 7 & 8 (Excel document)

Demonstration: Using the Normal Distribution (Chapter9), (Excel document)

Notes for Sampling Distributions, Standard Error & Central Limit Theorem (Chapter 10) (Excel document)

Interactive Demonstration: Excel demo comparing the t distribution to the Standard Normal (Excel document)

Overview for Confidence Intervals and Hypothesis Testing on 1 Parameter (Chapters 11, 12& 13) (Word document)

Inference on 1 Parameter [Confidence Interval & Hypothesis Testing](Chapters 11, 12 & 13) (Excel document)

Inference overview [Confidence Interval & Hypothesis Testing] (Excel document)

Simulation Demonstration: Excel Demo for Confidence Intervals (Excel document)

Simulation Demonstration: Excel Demo for Hypothesis Testing (Excel document)


SCMA 302 officially begins here

Overview of Hypothesis Testing Methods (with sections in 2nd edition Sharpe text) (Word document listing procedures)

Inference on 2 Location Parameters [Confidence Interval & Hypothesis Testing](Chapter 14) (Excel document)

List of Hypothesis Testing Procedures (Sharpe) & Excel functions (Excel document)

Analysis of Variance, ANOVA (Chapter 21) (Excel document)

Notes for Chapter 15, Chi-square Tests (Excel document)

Interactive Demonstration: Regression Demo (Excel document)

Notes on Regression for Chapters 16, 17, 18 & 19(Excel document)

Comprehensive Regression Example from section 10.9 of Canavos & Miller 1999 (Excel document)

Regression Examples (Excel document)

Sample Exercises for Selecting Procedure & Writing Null and Alternate Hypotheses (Excel document)

Logistic Regression covered in Section 18.6 (Excel document)
Logistic Regression Results for Failed Companies Data (Excel document)