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)