Information for Canavos & Miller statistics text (1999 edition)
Page last updated August 14, 2008
Dr. Robert L. Andrews, Instructor Solutions to Problems from the Canavos & Miller text

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.

Introductory Material, Melton & Chap. 1 & 13 in C&M(Excel document)

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

Chapter 2 Section 3, Distributions of Data (Excel document)

Measures of Location & Variation, Sections 2.4 & 2.5 in C&M (Excel document)

Measures of Relative Standing, Section 2.6 in C&M (Excel document)

Representing Relationships Between Two Variables, Section 2.7 in C&M (Excel document)

Excel Functions and Data Analysis Tools for Chapters 2 & 3 in C&M
(Word document)

Chapter 3 in C&M, Probability. (Excel document)

Chapter 4 in C&M, Probability Distributions. (Excel document)

Chapter 5 in C&M, Statistics & Sampling Distributions (Excel document)

Simulation Demonstration: Distribution of x-bar when sampling from a normal distribution (Excel document)

Simulation Demonstration: Central Limit with a Triangular Distribution (Excel document)

Simulation Demonstration: Central Limit with a Uniform Distribution (Excel document)

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

Chapter 6 in C&M, Inference for a Single Parameter (Excel document)

Handout for Confidence Intervals & Hypothesis Testing of a Single Parameter (Word document)

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

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

Handout for Confidence Intervals & Hypothesis Testing for 2 Groups (Word document)

Chapter 7 in C&M, Inferences for Two Phenomena (Excel document)

Chapter 8 in C&M, Analysis of Variance (Excel document)

Simulation Demonstration: Analysis of Variance (ANOVA) with 4 treatment groups (Excel document)

Chapter 11 in C&M, Goodness of fit & Test of Independence (Excel document)

Chapter 11 in C&M, Creating 2-way tables with Excel (Word document)

Chapter 9 & 10 in C&M, Regression (Excel document)

Interactive Demonstration: Regression Demo (Excel document)

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

Regression Examples (Excel document)