TY - BOOK AU - Pelosi,Marilyn K. AU - Sandifer,Theresa M. AU - Letkowski,Jerzy J. TI - Doing statistics with Excel 97: software instruction and exercise activity supplement SN - 0471251712 U1 - 519.5/0285/5369 21 PY - 1998/// CY - New York PB - J. Wiley & Sons KW - Microsoft Excel (Computer file) KW - Commercial statistics KW - Computer programs KW - Economics KW - Statistical methods N1 - 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 UR - http://www.loc.gov/catdir/description/wiley033/98138197.html UR - http://lcweb.loc.gov/catdir/toc/98-138197.html ER -