Statistical Analysis with Excel For Dummies (eBook)
528 Seiten
John Wiley & Sons (Verlag)
978-1-118-46434-2 (ISBN)
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.
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.
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)
| Sprache | englisch |
|---|---|
| Themenwelt | Informatik ► Office Programme ► Excel |
| Informatik ► Office Programme ► Outlook | |
| Schlagworte | Computer-Ratgeber • End-User Computing • Excel • Microsoft Excel |
| ISBN-10 | 1-118-46434-6 / 1118464346 |
| ISBN-13 | 978-1-118-46434-2 / 9781118464342 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
