You are previewing Even You Can Learn Statistics and Analytics: An Easy to Understand Guide to Statistics and Analytics, Third Edition.
O'Reilly logo
Even You Can Learn Statistics and Analytics: An Easy to Understand Guide to Statistics and Analytics, Third Edition

Book Description

Thought you couldn’t learn statistics? You can – and you will! Even You Can Learn Statistics and Analytics, Third Edition is the practical, up-to-date introduction to statistics – for everyone! Now fully updated for "big data" analytics and the newest applications, it'll teach you all the statistical techniques you’ll need for finance, marketing, quality, science, social science, and more – one easy step at a time. Simple jargon-free explanations help you understand every technique, and extensive practical examples and worked problems give you all the hands-on practice you'll need. This edition contains more practical examples than ever – all updated for the newest versions of Microsoft Excel. You'll find downloadable practice files, templates, data sets, and sample models – including complete solutions you can put right to work! Learn how to do all this, and more:

  • Apply statistical techniques to analyze huge data sets and transform them into valuable knowledge

  • Construct and interpret statistical charts and tables with Excel or OpenOffice.org Calc 3

  • Work with mean, median, mode, standard deviation, Z scores, skewness, and other descriptive statistics

  • Use probability and probability distributions

  • Work with sampling distributions and confidence intervals

  • Test hypotheses with Z, t, chi-square, ANOVA, and other techniques

  • Perform powerful regression analysis and modeling

  • Use multiple regression to develop models that contain several independent variables

  • Master specific statistical techniques for quality and Six Sigma programs

  • Hate math? No sweat. You’ll be amazed at how little you need. Like math? Optional "Equation Blackboard" sections reveal the mathematical foundations of statistics right before your eyes. If you need to understand, evaluate, or use statistics in business, academia, or anywhere else, this is the book you've been searching for!

    Table of Contents

    1. About This eBook
    2. Title Page
    3. Copyright Page
    4. Dedication Page
    5. Table of Contents
    6. Acknowledgments
    7. About the Authors
    8. Introduction
      1. Mathematics Is Always Optional!
      2. Learning with the Concept-Interpretation Approach
      3. Practicing Statistics While You Learn Statistics
      4. In-Chapter Aids
      5. End-of-Chapter Features
      6. New to the Third Edition
      7. Summary
    9. Chapter 1. Fundamentals of Statistics
      1. 1.1 The First Three Words of Statistics
      2. 1.2 The Fourth and Fifth Words
      3. 1.3 The Branches of Statistics
      4. 1.4 Sources of Data
      5. 1.5 Sampling Concepts
      6. 1.6 Sample Selection Methods
      7. One-Minute Summary
      8. Test Yourself
      9. Answers to Test Yourself
      10. References
    10. Chapter 2. Presenting Data in Tables and Charts
      1. 2.1 Presenting Categorical Variables
      2. 2.2 Presenting Numerical Variables
      3. 2.3 “Bad” Charts
      4. One-Minute Summary
      5. Test Yourself
      6. Answers to Test Yourself Short Answers
      7. Answers to Test Yourself Problems
      8. References
    11. Chapter 3. Descriptive Statistics
      1. 3.1 Measures of Central Tendency
      2. 3.2 Measures of Position
      3. 3.3 Measures of Variation
      4. 3.4 Shape of Distributions
      5. Important Equations
      6. One-Minute Summary
      7. Test Yourself
      8. References
    12. Chapter 4. Probability
      1. 4.1 Events
      2. 4.2 More Definitions
      3. 4.3 Some Rules of Probability
      4. 4.4 Assigning Probabilities
      5. One-Minute Summary
      6. Test Yourself
      7. References
    13. Chapter 5. Probability Distributions
      1. 5.1 Probability Distributions for Discrete Variables
      2. 5.2 The Binomial and Poisson Probability Distributions
      3. 5.3 Continuous Probability Distributions and the Normal Distribution
      4. 5.4 The Normal Probability Plot
      5. Important Equations
      6. One-Minute Summary
      7. Test Yourself
      8. References
    14. Chapter 6. Sampling Distributions and Confidence Intervals
      1. 6.1 Foundational Concepts
      2. 6.2 Sampling Error and Confidence Intervals
      3. 6.3 Confidence Interval Estimate for the Mean Using the t Distribution (σ Unknown)
      4. 6.4 Confidence Interval Estimation for Categorical Variables
      5. 6.5 Bootstrapping Estimation
      6. Important Equations
      7. One-Minute Summary
      8. Test Yourself
      9. References
    15. Chapter 7. Fundamentals of Hypothesis Testing
      1. 7.1 The Null and Alternative Hypotheses
      2. 7.2 Hypothesis Testing Issues
      3. 7.3 Decision-Making Risks
      4. 7.4 Performing Hypothesis Testing
      5. 7.5 Types of Hypothesis Tests
      6. One-Minute Summary
      7. Test Yourself
      8. Answers to Test Yourself
      9. References
    16. Chapter 8. Hypothesis Testing: Z and t Tests
      1. 8.1 Testing for the Difference Between Two Proportions
      2. 8.2 Testing for the Difference Between the Means of Two Independent Groups
      3. 8.3 The Paired t Test
      4. Important Equations
      5. One-Minute Summary
      6. Test Yourself
      7. References
    17. Chapter 9. Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA)
      1. 9.1 Chi-Square Test for Two-Way Cross-Classification Tables
      2. 9.2 One-Way Analysis of Variance (ANOVA): Testing for the Differences Among the Means of More Than Two Groups
      3. Important Equations
      4. One-Minute Summary
      5. Test Yourself
      6. References
    18. Chapter 10. Simple Linear Regression
      1. 10.1 Basics of Regression Analysis
      2. 10.2 Developing a Simple Linear Regression Model
      3. 10.3 Measures of Variation
      4. 10.4 Inferences About the Slope
      5. 10.5 Common Mistakes Using Regression Analysis
      6. Important Equations
      7. One-Minute Summary
      8. Test Yourself
      9. References
    19. Chapter 11. Multiple Regression
      1. 11.1 The Multiple Regression Model
      2. 11.2 Coefficient of Multiple Determination
      3. 11.3 The Overall F Test
      4. 11.4 Residual Analysis for the Multiple Regression Model
      5. 11.5 Inferences Concerning the Population Regression Coefficients
      6. One-Minute Summary
      7. Test Yourself
      8. References
    20. Chapter 12. Fundamentals of Analytics
      1. 12.1 Basic Vocabulary of Analytics
      2. 12.2 Software for Analytics
      3. One-Minute Summary
      4. Test Yourself
      5. References
    21. Chapter 13. Descriptive Analytics
      1. 13.1 Dashboards
      2. 13.2 Common Descriptive Analytics Visualizations
      3. One-Minute Summary
      4. Test Yourself
      5. References
    22. Chapter 14. Predictive Analytics
      1. 14.1 Analysis with Predictive Analytics
      2. 14.2 Classification and Regression Trees
      3. 14.3 Cluster Analysis
      4. 14.4 Multidimensional Scaling
      5. One-Minute Summary
      6. Test Yourself
      7. References
    23. Appendix A. Microsoft Excel Operation and Configuration
      1. A.S1 Spreadsheet Operation Conventions
      2. A.S2 Spreadsheet Technical Configurations
    24. Appendix B. Review of Arithmetic and Algebra
      1. Assessment Quiz
      2. Symbols
      3. Answers to Quiz
    25. Appendix C. Statistical Tables
    26. Appendix D. Spreadsheet Tips
      1. CT: Chart Tips
      2. FT: Function Tips
    27. Appendix E. Advanced Techniques
      1. ADV: Advanced How-Tos
      2. ATT: Analysis ToolPak Tips
    28. Appendix F. Documentation for Downloadable Files
      1. F.1 Downloadable Data Files
      2. F.2 Downloadable Spreadsheet Solution Files
    29. Glossary
    30. Index