Even You Can Learn Statistics and Analytics

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!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