Statistical Analysis with Excel For Dummies (3rd Edition)

Tag: Office

Posted on 2013-07-28, by bitsh01.

Description

Statistical Analysis with Excel For Dummies (3rd Edition)
by Joseph Schmuller

English | For Dummies | April 2013 | ISBN-10: 1118464311 | ePUB + PDF | 528 pages | 35 MB

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.
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. Learn to:
- Understand common statistical terms
- Interpret sales figures, gambling odds, sports stats, and more
- Use Excel formulas, functions, charts, and PivotTables
- Develop a grading curve or medical correlations
Forget the mumbo-jumbo!

Stunned by statistics? Exhausted by Excel? Relax! This book makes it easy to learn statistical analysis and actually use it to interpret the statistics of everyday life. Take your Excel knowledge to a new level as you discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and much more.

Open the book and find:
- A roundup of new Excel capabilities
- Different types of hypothesis testing
- Tools and instructions just for Mac users
- What ANOVA means and why you must know
- Statistical and graphical tips and traps
- How Excel can pinch-hit as a database
- What to do with random variables
- Appendixes that delve into specific tools and tricks

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.

Contents at a Glance
Introduction ................................................................ 1
Part I: Getting Started with Statistical
Analysis with Excel ...................................................... 7
Chapter 1: Evaluating Data in the Real World ................................................................9
Chapter 2: Understanding Excel's Statistical Capabilities ..........................................31
Part II: Describing Data ............................................. 63
Chapter 3: Show and Tell: Graphing Data .....................................................................65
Chapter 4: Finding Your Center .....................................................................................97
Chapter 5: Deviating from the Average .......................................................................113
Chapter 6: Meeting Standards and Standings ............................................................131
Chapter 7: Summarizing It All .......................................................................................147
Chapter 8: What's Normal? ...........................................................................................173
Part III: Drawing Conclusions from Data.................... 185
Chapter 9: The Confidence Game: Estimation ...........................................................187
Chapter 10: One-Sample Hypothesis Testing .............................................................203
Chapter 11: Two-Sample Hypothesis Testing ............................................................219
Chapter 12: Testing More Than Two Samples ...........................................................251
Chapter 13: Slightly More Complicated Testing ........................................................279
Chapter 14: Regression: Linear and Multiple .............................................................293
Chapter 15: Correlation: The Rise and Fall of Relationships....................................331
Part IV: Probability ................................................. 353
Chapter 16: Introducing Probability ............................................................................355
Chapter 17: More on Probability .................................................................................379
Chapter 18: A Career in Modeling ................................................................................393
Part V: The Part of Tens ........................................... 413
Chapter 19: Ten Statistical and Graphical Tips and Traps .......................................415
Chapter 20: Ten Things (Thirteen, Actually) That Just Didn't Fit in Any Other Chapter .........421
Appendix A: When Your Worksheet Is a Database....... 451
Appendix B: The Analysis of Covariance .................... 467
Index ...................................................................... 481
Bonus Appendix 1: When Your Data Live Elsewhere
Bonus Appendix 2: Tips for Teachers (And Learners)

http://bitshare.com/files/7niniu58/s021z.Statistical.Analysis.with.Excel.For.Dummies.3rd.Edition.rar.html

9798 dl's @ 3309 KB/s
5265 dl's @ 3905 KB/s
8267 dl's @ 2947 KB/s

Search More...
Statistical Analysis with Excel For Dummies (3rd Edition)

Related Books