Synopses & Reviews
Statistical skills are helpful in everyday life, especially in business and classroom settings. For example, you can use statistics to evaluate manufacturing output or “ curve” test scores. "Statistical Analysis with Excel For Dummies will show readers how to use the world’ s most popular spreadsheet program to crunch the numbers and interpret statistics— even if they haven’ t taken a statistics or advanced math course. Statistics have a reputation for being a challenging, math intensive pursuit. Using plain English and a minimum of equations, this book will get readers understanding statistics quickly and painlessly.
Veteran Excel author Curtis Frye will cover formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, and much more. By the end of the book readers will understand statistical terms such as median vs. mean, margin of error, standard deviation, permutations and correlations. Although this book was written on Excel 2003, the author’ s techniques can be done with earlier versions of Excel too.
Synopsis
- This book makes it easy to crunch numbers and interpret statistics with Excel, even for the math-challenged
- Using plain English and real-life examples, the author provides information that will help readers improve their performance on the job or in the classroom
- Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends and correlations, as well as statistical terms like median vs. mean, margin of error, standard deviation, permutations, and correlations-all using Excel
Synopsis
Create graphs, develop estimates, and apply probability
Get the scoop on all of Excel's statistical tools and what they can do for you
If "permutation" sounds like something you shouldn't say around your grandmother and you read "margin of error" as "margin of terror," take heart! This easy-to-follow guide explains statistics in plain English and shows you how to use Excel charts, functions, samples, and correlations to make sense of it all even if you're numerically challenged!
Discover how to
- Understand means, medians, and standard deviations
- Use Excel to give meaning to sets of numbers
- Draw conclusions from data
- Test your hypotheses
- Apply statistical concepts to real-world situations
About the Author
A veteran of over twenty years in Information Technology,
Joseph Schmuller is a Technical Architect at Blue Cross-Blue Shield of Florida. He is the author of several books on computing, including the three editions of
Teach Yourself UML in 24 Hours (SAMS), and he has written numerous articles on advanced technology. From 1991 through 1997, he was Editor-in-Chief of
PC AI magazine.
He is a former member of the American Statistical Association, and he has taught statistics at the undergraduate and graduate levels. He holds a B.S. from Brooklyn College, an M.A. from the University of Missouri-Kansas City, and a Ph.D. from the University of Wisconsin. He and his family live in Jacksonville, Florida, where he is an Adjunct Professor at the University of North Florida.
Table of Contents
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 Confidence 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 (Or so) Things That Didn’t Fit in Any Other Chapter.
Appendix: When Your Worksheet is a Database.
Index.