Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. An adjunct professor at the University of North Florida, he is a former member of the American Statistical Association and has taught statistics at the undergrad, honors undergrad, and graduate levels.
Part I: Getting Started with Statistical Analysis with Excel 7
Chapter 1: Evaluating Data in the Real World 9
Chapter 2: Understanding Excel’s Statistical Capabilities 31
Part II: Describing Data 63
Chapter 3: Show and Tell: Graphing Data 65
Chapter 4: Finding Your Center 97
Chapter 5: Deviating from the Average 113
Chapter 6: Meeting Standards and Standings 131
Chapter 7: Summarizing It All 147
Chapter 8: What’s Normal? 173
Part III: Drawing Conclusions from Data 185
Chapter 9: The Confi dence Game: Estimation 187
Chapter 10: One-Sample Hypothesis Testing 203
Chapter 11: Two-Sample Hypothesis Testing 219
Chapter 12: Testing More Than Two Samples 251
Chapter 13: Slightly More Complicated Testing 279
Chapter 14: Regression: Linear and Multiple 293
Chapter 15: Correlation: The Rise and Fall of Relationships 331
Part IV: Probability 353
Chapter 16: Introducing Probability 355
Chapter 17: More on Probability 379
Chapter 18: A Career in Modeling 393
Part V: The Part of Tens 413
Chapter 19: Ten Statistical and Graphical Tips and Traps 415
Chapter 20: Ten Things (Thirteen, Actually) That Just Didn’t Fit in Any Other Chapter 421
Appendix A: When Your Worksheet Is a Database 451
Appendix B: The Analysis of Covariance 467
Index 481
Bonus Appendix 1: When Your Data Live Elsewhere
Bonus Appendix 2: Tips for Teachers (And Learners)
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.