Excel Guide Revised; for Introduction to the Practice of Statistics 3e

by Fred Hoppe

• ISBN13: 9780716740032
• ISBN10: 0716740036
• Edition: 3rd
• Format: Trade Paper
• Copyright: 2000-01-15
• Publisher: W. H. Freeman

Table of Contents

Preface	vii
Introduction	1	(16)
What Is Excel?
The Excel Workbook
Components of the Workbook
Entering and Modifying Information
Opening Files
Printing
Whither?
Looking at Data---Distributions	17	(28)
Displaying Distributions with Graphs
The Chart Wizard
Histograms
Describing Distributions with Numbers
The Descriptive Statistics Tool
Formula Palette
The Normal Distribution
Normal Distribution Calculations
Graphing the Normal Curve
Constructing a Normal Table
Boxplots
Looking at Data-Relationship	45	(16)
Scatterplot
Creating a Scatterplot
Enhancing a Scatterplot
Normal Quantile Plots
Correlation
Least-Squares Regression
Fitting a Line to Data
Residuals
Producing Data	61	(6)
Samples with Replacement
Using the Sampling Tool
Simple Random Samples (SRS)
Random Digits
Using the RAND () Function
Probability: The Study of Randomness	67	(12)
Randomness
Simulating Bernoulli Random Variables
Probability Models
Random Variables
Simulating Random Variables
From Probability to Inference	79	(8)
Sampling Distributions for Counts and Proportions
The Binomial Distribution
Sampling Distribution of a Sample Mean
Simulating the Central Limit Theorem
Introduction to Inference	87	(6)
Estimating with Confidence
How Confidence Intervals Behave
Tests of Significance
Inference for Distributions	93	(24)
Inference for the Mean of a Population
The One-Sample t Confidence Interval
The One-Sample t Test
Matched Pairs t Procedure
Comparing Two Means
Two-Sample z Statistic
Two-Sample t Procedures
The Pooled Two-Sample t Procedures
Optional Topics in Comparing Distributions
Inference for Population Spread
The F Test for Equality of Spread
Inference for Proportions	117	(8)
Inference for a Single Proportion
Confidence Intervals
Significance Tests
Comparing Two Proportions
Confidence Intervals
Significance Tests
Inference for Two-Way Tables	125	(8)
Inference for Two-Way Tables
Expected Cell Counts
The Chi-Square Test
Formulas and Models for Two-Way Tables
Computing the Chi-Square Statistic
Inference for Regression	133	(18)
Simple Linear Regression
The Regression Tool
Excel Output
More Detail about Simple Linear Regression
ANOVA F and Regression Statistics
Inference about Predictions
Regression Functions
Multiple Regression	151	(8)
Multiple Linear Regression Model
Case Study
Estimation of Parameters and ANOVA Table
One-Way Analysis of Variance	159	(10)
The ANOVA Model
Testing Hypotheses in a One-Way ANOVA
Two-Way Analysis of Variance	169	(10)
The Two-Way ANOVA Model
The ANOVA Tool
The ANOVA Table for Two-Way ANOVA
Nonparametric Tests	179	(14)
The Wilcoxon Rank Sum Test
The Wilcoxon Signed Rank Test
The Kruskal-Wallis Test
Logistic Regression	193	(6)
Binomial Distributions and Odds
The Logistic Regression Model
Weighted Least-Squares
Fitting and Interpreting the Logistic Regression Model
Appendix--Excel 5/95	199	(22)
A.1 The ChartWizard
A.2 Histograms
A.3 The Function Wizard
A.4 Scatterplot
A.5 Boxplots
Index	221