Information for Sharpe, DeVeaux & Velleman statistics text (2010 edition)
Page last updated October 30, 2009
Dr. Robert L. Andrews, Instructor MGMT524 Home page

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.

Simulation Demonstration: Run Chart for determining process stability(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)

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)

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

Interactive Demonstration: Regression Demo (Excel document)

List of Hypothesis Testing Procedures from Sharpe text (Excel document)

Notes for Chapter 15, Chi-square Tests (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)