Information for Sharpe, DeVeaux & Velleman statistics text (2010 edition)
Page last updated May 24, 2011
Dr. Robert L. Andrews, Instructor MGMT524 Home page MGMT301

Media Player files to illustrate the use of Excel (2003 & earlier) (Web page)
Excel file showing some basics for using Excel 2007 for Statistics (Excel file)
I also have a file on my home page you can download to provide an interactive guide to find an Excel 2003 operation in Excel 2007.
Excel 2010 has some functions that are not in previous versions. Functions in previous versions work in 2010.

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)

Notes for Chapters 4, 5 & 21 (Excel document)

Notes for Chapter 6 (Excel document)

2 Quantitative Variable Relationships: X-Y Scatter, Correlation & Regression (Chapters 7&8) (Excel document)

Demonstration: Using the Normal Distribution (Excel document)

Notes for Standard Error, Central Limit Theorem & Confidence Interval for Proportion (Chapters 9&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 10, 11 & 12) (Word document)

Inference on 1 Parameter [Confidence Interval & Hypothesis Testing](Chapters 11&12) (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)

Inference on 2 Means [Confidence Interval & Hypothesis Testing](Chapters 13&14) (Excel document)

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

Analysis of Variance, ANOVA (Chapter 23) (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)