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!

DAVID M. LEVINE (New York, NY) is Professor Emeritus of Statistics and Computer Information Systems at Bernard M. Baruch College (City University of New York). He received B.B.A. and M.B.A. degrees in Statistics from City College of New York and a Ph.D. degree from New York University in Industrial Engineering and Operations Research. He is nationally recognized as a leading innovator in business statistics education and is the co-author of such best-selling statistics textbooks as Statistics for Managers using Microsoft Excel, Basic Business Statistics: Concepts and Applications, Business Statistics: A First Course, and Applied Statistics for Engineers and Scientists using Microsoft Excel and Minitab. He has published articles in various journals including Psychometrika, The American Statistician, Communications in Statistics, Multivariate Behavioral Research, Journal of Systems Management, Quality Progress, and The American Anthropologist.

 

DAVID F. STEPHAN (New York) is an instructional designer who has pioneered the classroom use of technology, and is a leader in making Excel more accessible to statistics students. He has co-authored several textbooks with David M. Levine.

Introduction: The Even You Can Learn Statistics and Analytics Owners Manual     xi
Chapter 1: Fundamentals of Statistics     1
Chapter 2: Presenting Data in Tables and Charts     15
Chapter 3: Descriptive Statistics     37
Chapter 4: Probability     67
Chapter 5: Probability Distributions     79
Chapter 6: Sampling Distributions and Confidence Intervals     113
Chapter 7: Fundamentals of Hypothesis Testing     137
Chapter 8: Hypothesis Testing: Z and t Tests     149
Chapter 9: Hypothesis Testing: Chi-Square Tests and the One-Way Analysis of Variance (ANOVA)      175
Chapter 10: Simple Linear Regression     203
Chapter 11: Multiple Regression     239
Chapter 12: Fundamentals of Analytics     257
Chapter 13: Descriptive Analytics     265
Chapter 14: Predictive Analytics     277
Appendix A: Microsoft Excel Operation and Configuration     293
Appendix B: Review of Arithmetic and Algebra     295
Appendix C: Statistical Tables     305
Appendix D: Spreadsheet Tips     333
Appendix E: Advanced Techniques     337
Appendix F: Documentation for Downloadable Files     345
Glossary     349
Index     357