Statistical Analysis with Excel For Dummies

Joseph Schmuller, PhD, is a Research Scholar at the University of North Florida. He is a former member of the American Statistical Association and has taught statistics at the undergraduate, honors undergraduate, and graduate levels.

Introduction 1 Part 1: Getting Started with Statistical Analysis with Excel: A Marriage Made in Heaven 7 CHAPTER 1: Evaluating Data in the Real World 9 CHAPTER 2: Understanding Excel s Statistical Capabilities 31 Part 2: Describing Data 61 CHAPTER 3: Show and Tell: Graphing Data 63 CHAPTER 4: Finding Your Center 101 CHAPTER 5: Deviating from the Average 117 CHAPTER 6: Meeting Standards and Standings 135 CHAPTER 7: Summarizing It All 151 CHAPTER 8: What s Normal? 171 Part 3: Drawing Conclusions from Data 183 CHAPTER 9: The Confidence Game: Estimation 185 CHAPTER 10: One-Sample Hypothesis Testing 199 CHAPTER 11: Two-Sample Hypothesis Testing 217 CHAPTER 12: Testing More Than Two Samples 249 CHAPTER 13: Slightly More Complicated Testing 275 CHAPTER 14: Regression: Linear and Multiple 295 CHAPTER 15: Correlation: The Rise and Fall of Relationships 331 CHAPTER 16: It s About Time 351 CHAPTER 17: Non-Parametric Statistics 363 Part 4: Probability 377 CHAPTER 18: Introducing Probability 379 CHAPTER 19: More on Probability 403 CHAPTER 20: A Career in Modeling 417 Part 5: The Part of Tens 437 CHAPTER 21: Ten Statistical and Graphical Tips and Traps 439 CHAPTER 22: Ten Things (Twelve, Actually) That Just Didn t Fit in Any Other Chapter 445 APPENDIX A: When Your Worksheet Is a Database 471 APPENDIX B: The Analysis of Covariance 487 Index 501