Statistical Analysis with Excel for Dummies

Statistical Analysis with Excel for Dummies

By Joseph Schmuller

For Dummies, Paperback, 9781118464311, 504pp.

Publication Date: April 1, 2013


Take the mystery out of statistical terms and put Excel to work

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

"Statistical Analysis with Excel For Dummies, 3rd Edition" helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.

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.