Doing statistics with Excel 97 : software instruction and exercise activity supplement / Marilyn K. Pelosi, Theresa M. Sandifer, Jerzy J. Letkowski.

CONTENTS

Chapter 1 An Introduction to the Workbook 1
Section 1. I Overview 1
Section 1.2 Objectives of the Workbook 1
Section 1.3 Description of the Data Sets 2
Section 1.4 Organization of the Workbook 2
Section 1.5 How to Use the Workbook 4
Section 1.6 Web Pages 4

Chapter 2 The Basics of Windows 5
Section 2.1 Overview 5
Section 2.2 Starting Windows 95 5
Section 2.3 The Windows 95 Desktop 5
Section 2.4 Using the Mouse 7
Section 2.5 Using the Keyboard 9
Section 2.6 Windows Structure and Behavior 14
Section 2.7 My Computer 22
Section 2.8 Windows Explorer 24
Section 2.9 Exiting Explorer and Windows 29

Chapter 3 The Basics in Microsoft Excel 97 31
Section 3.1 Overview 31
Section 3.2 Launching Excel 31
Section 3.3 Statistical Data in Excel 36
Section 3.4 Saving a Workbook 39
Section 3.5 Using Named References in Excel 41
Section 3.6 Printing Your Work 43
Section 3.7 Exiting Excel 47

Chapter 4 Displaying Qualitative Data 49
Section 4.1 Overview 49
Section 4.2 Problem Statement 49
Section 4.3 Characteristics of the Data Set 50
Section 4.4 Overview of Graphs in Excel 51
Section 4.5 How to Create Column Charts in Excel 51
Section 4.6 Clustered and Stacked Column Charts 66
Section 4.7 How to Create a Pie Chart in Excel 76
Section 4.8 Consolidating Data 83
Section 4.9 Pareto Diagrams 87
Section 4.10 Looking at the Data for Different Time Periods 89
Section 4.11 Investigative Exercises 90

Chapter 5 Displaying Quantitative Data 95
Section 5.1 Overview 95
Section 5.2 Problem Statement 95
Section 5.3 Characteristics of the Data Set 97
Section 5.4 How to Create a Histogram in Excel 99
Section 5.5 Creating Histograms for Subsets of a Variable 117
Section 5.6 Investigative Exercises 129

Chapter 6 Numerical Descriptors 135
Section 6.1 Overview 135
Section 6.2 Problem Statement 135
Section 6.3 Generating Descriptive Statistics for an Entire
Column of data 136
Section 6.4 Generating Descriptive Statistics for Grouped Data 146
Section 6.5 Descriptive Statistics Tool Versus Excel Functions 156
Section 6.6 Creating a Boxplot and Detecting Outliers 157
Section 6.7 Investigative Exercises 162

Chapter 7 A Study of The Binomial Distribution 169
Section 7.1 Overview 169
Section 7.2 Problem Statement 170
Section 7.3 Characteristics of the Data Set 170
Section 7.4 Detecting a Binomial Variable 172
Section 7.5 The Binomial Distribution in Excel 174
Section 7.6 Plotting the Binomial Distribution in Excel 179
Section 7.7 Estimating the Probability of Success, p 182
Section 7.8 The Beginnings of Hypothesis Testing 188
Section 7.9 Investigative Exercises 191

Chapter 8 A Study of the Normal Distribution 193
Section 8.1 Overview 193
Section 8.2 Problem Statement 193
Section 8.3 Characteristics of the Data Set 195
Section 8.4 Normal Distribution in Excel 196
Section 8.5 Plotting the Normal Distribution 203
Section 8.6 Changing the Normal Distribution 205
Section 8.7 Empirical Rules for Testing Normality 208
Section 8.8 Investigative Exercises 215

Chapter 9 A Study of the Central Limit Theorem 219
Section 9.1 Overview 219
Section 9.2 Problem Statement 219
Section 9.3 Characteristics of the Data Set 220
Section 9.4 Finding Sample Means 221
Section 9.5 The Central Limit Theorem 227
Section 9.6 Control Charts in Excel 227
Section 9.7 Investigative Exercises 237

Chapter 10 Hypothesis Tests - One Population 241
Section 10.1 Overview 241
Section 10.2 Problem Statement 241
Section 10.3 Characteristics of the Data Set 242
Section 10.4 Testing a Hypothesis 243
Section 10.5 Hypothesis Testing in Excel 244
Section 10.6 Interpreting the Test Output 245
Section 10.7 After the Test - Now What? 247
Section 10.8 Other Considerations 250
Section 10.9 Investigative Exercises 251

Chapter 11 Hypothesis Tests -Two Populations 255
Section 11. I Overview 255
Section 11.2 Problem Statement 255
Section 11.3 Characteristics of the Data Set 256
Section 11.4 Hypothesis Testing - Two Populations 257
Section 11.5 Investigative Exercises 266

Chapter 12 Testing Proportions 269
Section 12.1 Overview 269
Section 12.2 Problem Statement 269
Section 12.3 Characteristics of the Data Set 270
Section 12.4 Creating Cross Tabulation Tables in Excel 272
Section 12.5 Hypothesis Test on a Single Proportion Using Excel 279
Section 12.6 Comparing Two Proportions: Hypothesized
Difference of Zero 286
Section 12.7 Investigative Exercises 292

Chapter 13 Chi-Square Test for Independence 299
Section 13.1 Overview 299
Section 13.2 Problem Statement 299
Section 13.3 Chi-Square Test for Independence 299
Section 13.4 Investigative Exercises 306

Chapter 14 Linear Regression and Correlation 309
Section 14.1 Overview 309
Section 14.2 Problem Statement 309
Section 14.3 Characteristics of the Data Set 310
Section 14.4 Regression and Correlation 311
Section 14.5 Looking for Relationships 312
Section 14.6 Measuring Relationships 317
Section 14.7 Finding the Regression Model 319
Section 14.8 Testing Significance of the Model 320
Section 14.9 Examining the Fit of the Model 323
Section 14.10 Interpolation and Extrapolation 326
Section 14.11 Investigative Exercises 331

Chapter 15 Pulling It All Together 335
Section 15.1 Overview 335
Section 15.2 Problem Statement 335
Section 15.3 Characteristics of the Data Set 337
Section 15.4 Investigative Exercises 338

"This disk contains data files for use in workbook chapters 4 through 15"--Label on disk.