A clear and easy-to-understand guide on using Excel to create and interpret statistics * Shows readers how to use Excel for statistical analysis--even if they haven't taken a statistics class or if they're math-challenged--and helps them confidently use Excel to crunch the numbers and interpret the statistics of everyday life, from business and sports stats to gambling odds and medical correlations * Covers formulas and functions, charts and PivotTables, samples and normal distributions, and probabilities and related distributions * Demystifies statistical terms such as median vs. mean, margin of error, standard deviation, permutations, and correlations Joseph Schmuller, PhD (Jacksonville, FL), is a technical architect at Blue Cross-Blue Shield of Florida. He is the author of several books and numerous articles on advanced technology.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Editions-Typ
Illustrationen
Maße
Höhe: 230 mm
Breite: 186 mm
Dicke: 28 mm
Gewicht
ISBN-13
978-0-470-45406-0 (9780470454060)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. A former member of the American Statistical Association, he has taught statistics at the undergraduate, honors undergraduate, and graduate levels, and has been honored with an award for excellence in teaching.
Introduction. Part I: Statistics and Excel: A Marriage Made in Heaven. Chapter 1: Evaluating Data in the Real World. Chapter 2: Understanding Excel's Statistical Capabilities. Part II: Describing Data. Chapter 3: Show and Tell: Graphing Data. Chapter 4: Finding Your Center. Chapter 5: Deviating from the Average. Chapter 6: Meeting Standards and Standings. Chapter 7: Summarizing It All. Chapter 8: What's Normal? Part III: Drawing Conclusions from Data. Chapter 9: The Confi dence Game: Estimation. Chapter 10: One-Sample Hypothesis Testing. Chapter 11: Two-Sample Hypothesis Testing. Chapter 12: Testing More Than Two Samples. Chapter 13: Slightly More Complicated Testing. Chapter 14: Regression: Linear and Multiple. Chapter 15: Correlation: The Rise and Fall of Relationships. Part IV: Working with Probability. Chapter 16: Introducing Probability. Chapter 17: More on Probability. Chapter 18: A Career in Modeling. Part V: The Part of Tens. Chapter 19: Ten Statistical and Graphical Tips and Traps. Chapter 20: Ten Things (Twelve, Actually) That Didn't Fit in Any Other Chapter. Appendix A: When Your Worksheet Is a Database. Appendix B: The Analysis of Covariance. Appendix C: Of Stems, Leaves, Boxes, Whiskers, and Smoothies. Index.
