Even You Can Learn Statistics and Analytics: An Easy to Understand Guide, 4th edition

Published by Addison-Wesley Professional (June 8, 2022) © 2022

  • David M. Levine Baruch College, City University of New York
  • David F. Stephan Two Bridges Instructional Technology
Products list
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list

Details

  • A print text
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

Now fully updated for "big data" analytics and the newest applications, Even You Can Learn Statistics and Analytics, Fourth Edition is the practical, up-to-date introduction to statistics an analytics—for everyone!

One easy step at a time, you'll learn all the statistical techniques you'll need for finance, marketing, quality, science, social science, or anything else. Simple jargon-free explanations help you understand every technique, and realistic 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 in business, school, or anywhere else. 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! Thought you couldn't learn statistics? You can—and you will!

Introduction The Even You Can Learn Statistics and Analytics Owner's Manual. xiii

Chapter 1 Fundamentals of Statistics. 1

    1.1 The First Three Words of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

    1.2 The Fourth and Fifth Words. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

    1.3 The Branches of Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

    1.4 Sources of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

    1.5 Sampling Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

    1.6 Sample Selection Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Chapter 2 Presenting Data in Tables and Charts . 15

    2.1 Presenting Categorical Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

    2.2 Presenting Numerical Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

    2.3 “Bad” Charts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29

Chapter 3 Descriptive Statistics. 45

    3.1 Measures of Central Tendency. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

    3.2 Measures of Position. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

    3.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

    3.4 Shape of Distributions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Chapter 4 Probability. 75

    4.1 Events. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75

    4.2 More Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76

    4.3 Some Rules of Probability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78

    4.4 Assigning Probabilities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

Chapter 5 Probability Distributions. 87

    5.1 Probability Distributions for Discrete Variables. . . . . . . . . . . . . . . . . . . . . . . . 87

    5.2 The Binomial and Poisson Probability Distributions. . . . . . . . . . . . . . . . . . . . 93

    5.3 Continuous Probability Distributions and the Normal Distribution . . . . . . . 100

    5.4 The Normal Probability Plot. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108

Chapter 6 Sampling Distributions and Confidence Intervals. 121

    6.1 Foundational Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122

    6.2 Sampling Error and Confidence Intervals. . . . . . . . . . . . . . . . . . . . . . . . . . . 125

    6.3 Confidence Interval Estimate for the Mean Using the t Distribution (? Unknown). . . 128

    6.4 Confidence Interval Estimation for Categorical Variables . . . . . . . . . . . . . . . 131

    6.5 Confidence Interval Estimation When Normality Cannot Be Assumed. . . . . 134

Chapter 7 Fundamentals of Hypothesis Testing. 145

    7.1 The Null and Alternative Hypotheses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145

    7.2 Hypothesis Testing Issues. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147

    7.3 Decision-Making Risks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

    7.4 Performing Hypothesis Testing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150

    7.5 Types of Hypothesis Tests. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152

Chapter 8 Hypothesis Testing: Z and t Tests. 157

    8.1 Test for the Difference Between Two Proportions . . . . . . . . . . . . . . . . . . . . . 157

    8.2 Test for the Difference Between the Means of Two Independent Groups . . . . 163

    8.3 The Paired t Test. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168

Chapter 9 Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA). 183

    9.1 Chi-Square Test for Two-Way Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183

    9.2 One-Way Analysis of Variance (ANOVA): Testing for the

    Differences Among the Means of More Than Two Groups. . . . . . . . . . . . . . . 191

Chapter 10 Simple Linear Regression. 211

    10.1 Basics of Regression Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211

    10.2 Developing a Simple Linear Regression Model. . . . . . . . . . . . . . . . . . . . . . 214

    10.3 Measures of Variation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221

    10.4 Inferences About the Slope. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226

    10.5 Common Mistakes When Using Regression Analysis . . . . . . . . . . . . . . . . . 229

Chapter 11 Multiple Regression. 243

    11.1 The Multiple Regression Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243

    11.2 Coefficient of Multiple Determination . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246

    11.3 The Overall F Test . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246

    11.4 Residual Analysis for the Multiple Regression Model . . . . . . . . . . . . . . . . . 247

    11.5 Inferences Concerning the Population Regression Coefficients. . . . . . . . . . 248

Chapter 12 Introduction to Analytics. 259

    12.1 Basic Concepts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259

    12.2 Descriptive Analytics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265

    12.3 Typical Descriptive Analytics Visualizations. . . . . . . . . . . . . . . . . . . . . . . . 269

Chapter 13 Predictive Analytics. 279

    13.1 Predictive Analytics Methods. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279

    13.2 More About Predictive Models. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281

    13.3 Tree Induction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284

    13.4 Clustering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287

    13.5 Association Analysis. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290

Appendix A Microsoft Excel Operation and Configuration . 299

Appendix B Review of Arithmetic and Algebra. 301

Appendix C Statistical Tables. 311

Appendix D Spreadsheet Tips . 339

Appendix E Advanced Techniques. 343

Appendix F Documentation for Downloadable Files. 353



9780137654765, TOC, 4/25/2022


Need help? Get in touch