Dummies.com
  • Print
  • Share
Statistical Analysis with Excel For Dummies, 3rd Edition (1118464311) cover image

Statistical Analysis with Excel For Dummies, 3rd Edition

ISBN: 978-1-118-46431-1
Paperback
528 pages
April 2013
US $29.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

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)

  • Print
  • Share