The Excel Statistics Companion Version 2.0

Kenneth M. Rosenberg - Collection Wadsworth

220 pages, parution le 15/01/2006

Ajouter à une liste

Indisponible

Résumé

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.

Sommaire

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

Part1: EXERCISE PACKET (IN BOTH THE MANUAL AND ON THE CD-ROM).
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.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Thomson
Auteur(s)	Kenneth M. Rosenberg
Collection	Wadsworth
Parution	15/01/2006
Nb. de pages	220
Format	18,5 x 23
Couverture	Broché
Poids	440g
Intérieur	Noir et Blanc
EAN13	9780495186953
ISBN13	978-0-495-18695-3