The Excel Statistics Companion CD-ROM and Manual, Version 2.0

Kenneth M. Rosenberg has been writing innovative educational materials for statistics and research methods courses for over 20 years. In 1969, after getting his Ph. D. from Purdue University, Professor Rosenberg joined the faculty of the State University of New York, Oswego where he has regularly taught Principles of Human Behavior, Research Methods, and Analysis of Psychological Data (Statistics).

Contents of the CD-ROM. Basic Skills. Function List. 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. Basic Skills. 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.