List price: $64.75
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.
New to the Edition
Features
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.
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.
New to the Edition
Features
Table of Contents
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.