Statistical Analysis with Excel For Dummies (4^th Ed.)

Learn all of Excel′s statistical tools

Test your hypotheses and draw conclusions

Use Excel to give meaning to your data

Use Excel to interpret stats

Statistical analysis with Excel is incredibly useful and this book shows you that it can be easy, too! You′ll discover how to use Excel′s perfectly designed tools to analyze and understand data, predict trends, make decisions, and more. Tackle the technical aspects of Excel and start using them to interpret your data!

Inside...

• Covers Excel 2016 for Windows® & Mac® users
• Check out new Excel stuff
• Make sense of worksheets
• Create shortcuts
• Tool around with analysis
• Use Quick Statistics
• Graph your data
• Work with probability
• Handle random variables

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

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.