Statistical Analysis with Excel For Dummies

Joseph Schmuller

John Wiley & Sons, Mar 14, 2013 - Computers - 528 pages

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.

Contents

• The Part of Tens 4 73: 4
• Introduction: 5
• Getting Started with Statistical: 7
• Getting Started with Statistical: 24
• Describing: 63
• Finding Your Center: 97
• Deviating from the Average: 113
• Meeting Standards and Standings: 131
• Summarizing It All: 147
• Whats Normal?: 173
• Drawing Conclusions from Data 785: 185
• The Confidence Game Estimation: 187
• OneSample Hypothesis Testing: 203
• TwoSample Hypothesis Testing: 219
• Testing More Than Two Samples: 251
• Slightly More Complicated Testing: 279
• Regression Linear and Multiple: 293
• Correlation The Rise and Fall of Relationships: 331
• Probability: 353
• More on Probability: 379
• A Career in Modeling: 393
• Ten Statistical and Graphical Tips and Traps: 415
• Ten Things Thirteen Actually: 421
• Probabilities and Distributions: 429
• When your Worksheet Is a Database: 451
• When your Worksheet Is a Database: 457
• The Analysis of Covariance: 467
• 7: 481
• When your Data Live Elsewhere: 521

About the author

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.

Bibliographic information

• Title: Statistical Analysis with Excel For Dummies; --For dummies; EBL ebooks online; FinancePro collection
• Author: Joseph Schmuller
• Edition: 3, illustrated
• Publisher: John Wiley & Sons, 2013
• ISBN: 111846432X, 9781118464328
• Length: 528 pages
• Subjects: Computers / Business & Productivity Software / Spreadsheets; Computers / Desktop Applications / General; Computers / Software Development & Engineering / General