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

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.

Master statistical concepts and computational procedures with EXCEL STATISTICS COMPANION ON CD-ROM AND MANUAL! A collection of demonstrations, sampling experiments, and interactive experiments, this CD-ROM/manual package provides you with hands-on experience you need to succeed in statistics. With on-screen instructions, reviews, and step-by-step approaches, you will easily learn basic statistical concepts and how to use computer programs to solve problems.