Schmuller J. Statistical Analysis with Excel for Dummies

Wiley, 2013. – 528 p. – 3rd ed. – ISBN: 1118464311, 9781118464311Take 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.Getting Started with Statistical Analysis with Excel
Evaluating Data in the Real World
Understanding Excel’s Statistical Capabilities
Describing Data
Show and Tell: Graphing Data
Finding Your Center
Deviating from the Average
Meeting Standards and Standings
Summarizing It All
What’s Normal?
Drawing Conclusions from Data
The Confi dence Game: Estimation
One-Sample Hypothesis Testing
Two-Sample Hypothesis Testing
Testing More Than Two Samples
Slightly More Complicated Testing
Regression: Linear and Multiple
Correlation: The Rise and Fall of Relationships
Probability
Introducing Probability
More on Probability
A Career in Modeling
The Part of Tens
Ten Statistical and Graphical Tips and Traps
Ten Things (Thirteen, Actually) That Just Didn’t Fit in Any Other ChapterAppendix A: When Your Worksheet Is a Database
Appendix B: The Analysis of CovarianceBonus Appendix 1: When Your Data Live Elsewhere
Bonus Appendix 2: Tips for Teachers (And Learners)