Even You Can Learn Statistics and Analytics

Introduction

• Mathematics Is Always Optional!
• Learning with the Concept-Interpretation Approach

Fundamentals of Statistics

• The First Three Words of Statistics
• The Fourth and Fifth Words
• The Branches of Statistics
• Sources of Data
• Sampling Concepts
• Sample Selection Methods
• One-Minute Summary
• References

Presenting Data in Tables and Charts

• Presenting Categorical Variables
• Presenting Numerical Variables
• “Bad” Charts
• One-Minute Summary
• References

Descriptive Statistics

• Measures of Central Tendency
• Measures of Position
• Measures of Variation
• Shape of Distributions
• Important Equations
• One-Minute Summary
• References

Probability

• Events
• More Definitions
• Some Rules of Probability
• Assigning Probabilities
• One-Minute Summary
• References

Probability Distributions

• Probability Distributions for Discrete Variables
• The Binomial and Poisson Probability Distributions
• Continuous Probability Distributions and the Normal Distribution
• The Normal Probability Plot
• Important Equations
• One-Minute Summary
• References

Sampling Distributions and Confidence Intervals

• Foundational Concepts
• Sampling Error and Confidence Intervals
• Confidence Interval Estimate for the Mean Using the t Distribution (σ Unknown)
• Confidence Interval Estimation for Categorical Variables
• Confidence Interval Estimation When Normality Cannot Be Assumed
• Important Equations
• One-Minute Summary
• References

Fundamentals of Hypothesis Testing

• The Null and Alternative Hypotheses
• Hypothesis Testing Issues
• Decision-Making Risks
• Performing Hypothesis Testing
• Types of Hypothesis Tests
• One-Minute Summary
• References

Hypothesis Testing: Z and t Tests

• Test for the Difference Between Two Proportions
• Test for the Difference Between the Means of Two Independent Groups
• The Paired t Test
• Important Equations
• One-Minute Summary
• References

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

• Chi-Square Test for Two-Way Tables
• One-Way Analysis of Variance (ANOVA): Testing fo...ferences Among the Means of More Than Two Groups
• Important Equations
• One-Minute Summary
• References

Simple Linear Regression

• Basics of Regression Analysis
• Developing a Simple Linear Regression Model
• Measures of Variation
• Inferences About the Slope
• Common Mistakes When Using Regression Analysis
• Important Equations
• One-Minute Summary
• References

Multiple Regression

• The Multiple Regression Model
• Coefficient of Multiple Determination
• The Overall F Test
• Residual Analysis for the Multiple Regression Model
• Inferences Concerning the Population Regression Coefficients
• One-Minute Summary
• References

Introduction to Analytics

• Basic Concepts
• Descriptive Analytics
• Typical Descriptive Analytics Visualizations
• One-Minute Summary
• References

Predictive Analytics

• Predictive Analytics Methods
• More About Predictive Models
• Tree Induction
• Clustering
• Association Analysis
• One-Minute Summary
• References

Appendix A: Microsoft Excel Operation and Configuration

• Conventions for Keystroke and Mouse Operations
• Microsoft Excel Technical Configuration

Appendix B: Review of Arithmetic and Algebra

• Symbols

Appendix C: Statistical Tables

Appendix D: Spreadsheet Tips

• Chart Tips
• Function Tips

Appendix E: Advanced Techniques

• Advanced How-To Tips
• Analysis ToolPak Tips