The EXCEL STATISTICS COMPANION CD-ROM AND MANUAL, VERSION 2.0 is a collection of demonstrations, sampling experiments, and interactive exercises that dovetails with traditional textbook coverage of descriptive and inferential statistics. The materials give students the hands-on experience they need to master abstract statistical concepts and computational procedures. Microsoft® Excel®'s spreadsheet capabilities for data generation and instant dynamic response to user input provide a platform for teaching statistics that goes beyond the usual verbal and visual textbook explanations. All the workbooks on this CD-ROM contain detailed on-screen instructions. For Microsoft® Windows® and Excel novices, additional documentation (with extensive use of screen captures) appears in the companion ESC USER'S MANUAL. Carefully coordinated with the workbooks, the USER'S MANUAL begins with a basic skills workbook that reviews the limited subset of Excel and Windows skills needed to navigate and run the main body of programs. VERSION 2.0 includes four new workbooks and several new worksheets within existing workbooks, as well as a line-by-line edit to increase clarity and streamline pedagogy.
Table of Contents
Contents of the CD-ROM.
Folder 01: DESCRIPTIVE STATISTICS.
1-1 Describing Data. 1-2 Functions and Tools. 1-3 Frequency Distributions. 1-4 Making Charts. 1-5 Practice Describing.
Folder 02: THE Z STATISTIC.
2-1 Standardizing. 2-2 Comparing Distributions. 2-3 Applying z.
Folder 03: CORRELATION AND REGRESSION.
3-1 Patterns of Association. 3-2 Type 1 Error. 3-3 Pearson r. 3-4 Spearman rho. 3-5 Point Biserial. 3-6 Linear Regression.
Folder 04: SAMPLING DISTRIBUTIONS.
4-1 The Binomial. 4-2 Central Limit Theorem.
Folder 05: PROBABILITY.
5-1 Computing Probability. 5-2 Solving Problems.
Folder 06: THE t STATISTIC - 1 SAMPLE.
6-1 Estimating Error. 6-2 Rationale of the t Test. 6-3 Confidence Intervals. 6-4 Testing the Pearson r.
Folder 07: THE t STATISTIC - 2 SAMPLES.
7-1 Inside the t Test. 7-2 Estimating Error. 7-3 Paired-Samples t Test. 7-4 Statistical Power. 7-5 Independent vs Related.
Folder 08: SINGLE-FACTOR ANOVA.
8-1The ANOVA Model. 8-2 Independent vs Related. 8-3 Unplanned Comparisons.
Folder 09: TWO-FACTOR ANOVA.
9-1 Interpreting Results. 9-2 Creating Patterns. 9-3 Computational Method. 9-4 Mixed Two-Way ANOVA.
Folder 10: NONPARAMETRIC STATISTICS.
10-1 Chi-Sq Goodness-of-Fit. 10-2 Chi-Sq Independence. 10-3 Mann-Whitney. 10-4 Wilcoxon.
Folder 11: CAPSTONE.
11-1 Test Selection.
Contents of the Manual Preface.
Part1: EXERCISE PACKET (IN BOTH THE MANUAL AND ON THE CD-ROM).
1-1 Describing Data. 1-2 Functions and Tools. 1-3 Frequency Distributions. 1-4 Making Charts. 2-1 Standardizing Distributions. 2-2 Comparing Distributions. 3-1 Patterns of Association. 3-2 An Empirical Demonstration of Type 1 Error. 3-3 Pearson r. 3-4 Spearman rho (rs). 3-5 Point Biserial Correlation. 3-6 Linear Regression.
Periodic Review 1: Practice Problems for Correlation and Regression.
4-1 The Binomial Sampling Distribution. 4-2 An Empirical Demonstration of the Central Limit Theorem. 5-1 Computing Probability. 6-1 Estimating Error. 6-2 Rationale of the Single-Sample t Test. 6-3 Confidence Intervals. 6-4 Testing the Pearson r.
Periodic Review 2: Introduction to Hypothesis Testing.
7-1 Inside the t Test. 7-2 Estimating Error. 7-3 The Paired-Samples t Test. 7-4 Statistical Power. 7-5 Independent Groups versus Paired Samples.
Periodic Review 3: Two-Treatment Practice Problems.
8-1 The ANOVA Model. 8-2 The Single-Factor ANOVA: Related versus Independent Samples. 8-3 Unplanned Comparisons. Periodic Review 4: Single-Factor ("One-Way") Anova. 9-1 Interpreting Results. 9-2 Creating Patterns. 9-3 Computational Method for the Two-Factor ANOVA. 9-4 The Mixed Two-Factor Design. 10-1 The Chi-Square Goodness of Fit Test. 10-2 The Chi-Square Test of Independence. 10-3 The Mann-Whitney U Test. 10-4 The Wilcoxon Matched-Pairs Signed-Rank Test. 11-1 Test Selection.
Part II: ANNOTATED SCREEN CAPTURES FROM THE ESC CD-ROM.
Chapter 1. Descriptive Statistics.
Chapter 2. The z Statistic.
Chapter 3. Correlation & Regression.
Chapter 4. Sampling Distributions.
Chapter 5. Probability.
Chapter 6. The t test - One Sample.
Chapter 7. The t test - Two Samples.
Chapter 8. Single-Factor ANOVA.
Chapter 9. Two-Factor ANOVA.
Chapter 10. Nonparametric Statistics.
Chapter 11. Capstone.