Read more
Explains how to use Microsoft Excel in statistical analysis, covering Excel 2013's new features; worksheet functions associated with mean, median, and mode; estimating with sampling distributions; and importing data from databases.
List of contents
Introduction 1
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)
