Statistical Analysis with Excel For Dummies (eBook)

Joseph Schmuller (Autor)

eBook Download: EPUB

2013 | 3. Auflage
528 Seiten
John Wiley & Sons (Verlag)
978-1-118-46432-8 (ISBN)

Infos

Take the mystery out of statistical terms and put Excel towork!

If you need to create and interpret statistics in business orclassroom settings, this easy-to-use guide is just what you need.It shows you how to use Excel's powerful tools for statisticalanalysis, even if you've never taken a course in statistics. Learnthe meaning of terms like mean and median, margin of error,standard deviation, and permutations, and discover how to interpretthe statistics of everyday life. You'll learn to use Excelformulas, charts, PivotTables, and other tools to make sense ofeverything from sports stats to medical correlations.
* Statistics have a reputation for being challenging andmath-intensive; this friendly guide makes statistical analysis withExcel easy to understand
* Explains how to use Excel to crunch numbers and interpret thestatistics of everyday life: sales figures, gambling odds, sportsstats, a grading curve, and much more
* Covers formulas and functions, charts and PivotTables, samplesand normal distributions, probabilities and related distributions,trends, and correlations
* Clarifies statistical terms such as median vs. mean, margin oferror, standard deviation, correlations, and permutations

Statistical Analysis with Excel For Dummies, 3rd Editionhelps you make sense of statistics and use Excel's statisticalanalysis tools in your daily life.

Autor

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.

Inhalt

Introduction 1

Part I: Getting Started with Statistical Analysis withExcel 7

Chapter 1: Evaluating Data in the Real World 9

Chapter 2: Understanding Excel's Statistical Capabilities31

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 Relationships331

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 JustDidn'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)

Produkt-Details

• Erscheint lt. Verlag: 14.3.2013
• Sprache: englisch
• Themenwelt: Informatik ► Office Programme ► Excel
• Themenwelt: Informatik ► Office Programme ► Outlook
• Schlagworte: Computer-Ratgeber • End-User Computing • Excel • Microsoft Excel
• ISBN-10: 1-118-46432-X / 111846432X
• ISBN-13: 978-1-118-46432-8 / 9781118464328