Statistical Analysis with Excel For Dummies

Learn to:

• Understand common statistical terms
• Interpret sales figures, gambling odds, sports stats, and more
• Use Excel formulas, functions, charts, and PivotTables
• Develop a grading curve or medical correlations

Forget the mumbo–jumbo!

Statistical analysis with Excel can be easy and useful, too

Stunned by statistics? Exhausted by Excel? Relax! This book makes it easy to learn statistical analysis and actually use it to interpret the statistics of everyday life. Take your Excel knowledge to a new level as you discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and much more.

• The scoop on stats learn about statistical concepts such as samples and populations, variables, and probability
• New Excel stuff check out naming conventions, new functions, and other elements that are different in Excel 2013
• Striking sparks discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trends
• Means to an end understand means, medians, and modes and the worksheet functions associated with them
• Reasonable estimation work with sampling distributions for estimation and understand the all–important Central Limit Theorem
• It's probable explore Excel's rich set of built–in capabilities for understanding and applying probability
• Send in the data see how to import data from databases, the web, or from text

Open the book and find:

• A roundup of new Excel capabilities
• Different types of hypothesis testing
• Tools and instructions just for Mac users
• What ANOVA means and why you must know
• Statistical and graphical tips and traps
• How Excel can pinch–hit as a database
• What to do with random variables
• Appendixes that delve into specific tools and tricks

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)

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.