Statistics Introduction and Definitions
- Introduction and Welcome
- Statistics Defined
Basics of Statistics and Microsoft Excel
- Section Introduction - Basics of Statistics and Excel
- Excel Interface (Excel)
- Types of Data in Excel - Text, Numbers, Date/Time, Logical (Excel)
- Qualitative vs Quantitative Data / Continuous vs Discrete (Theory)
- Measurement Scales - Nominal, Ordinal, Interval & Ratio (Theory)
- Basic Statistical Terms - Population and Sample (Theory)
- Understanding Data Types in mtcars Dataset (Excel)
- Understanding Formulas and Functions (Excel)
- Applying Formula to Convert Car Weights from lb to kg (Excel)
- Relative vs Absolute Reference (Excel)
- Basic Formulas, Functions and Named Ranges (Excel)
- More Functions (Excel)
- Practice Activity - Basics of Statistics and Excel - Quiz 1
Descriptive Statistics
- Section Introduction - Descriptive Statistics
- Descriptive Statistics (Theory)
- Descriptive Statistics - Central Tendency (Theory)
- Descriptive Statistics - Variation (Theory)
- Installing Data Analysis Pack and Calculating Descriptive Statistics (Excel)
- Descriptive Statistics - Central Tendency (Excel)
- Descriptive Statistics - Variation (Excel)
- Descriptive Statistics - Shapes (Theory and Excel)
- Arrays (Excel)
- Practice Activity - Descriptive Statistics - Quiz 2
Data Visualization
- Section Introduction - Three commonly used Charts
- Histogram (Theory)
- Create Histogram (Excel)
- Histogram Shapes (Theory)
- Box and Whisker Chart (Theory)
- Create Box and Whisker Plot (Excel)
- Scatter Diagram (Theory)
- Create Scatter Plot using Excel
- Practice Activity - Data Visualization - Quiz 3
Basic Probability Concepts
- Section Introduction - Basics Probability Concepts
- Basic Probability Concepts - Part 1 (Theory)
- Basic Probability Concepts - Part 2 (Theory)
- Basic Probability Concepts - Part 3 (Theory)
- Basic Probability Concepts - Part 4 (Theory)
- Calculate Factorial, Permutations and Combinations (Excel)
- Practice Activity - Basic Probability Concepts - Quiz 4
Probability Distributions
- Section Introduction - Probability Distributions
- Central Limit Theorem (Theory)
- Central Limit Theorem Demonstration (Excel)
- Normal Probability Distribution (Theory)
- Normal Probability Distribution (Excel)
- Binomial Probability Distribution (Theory)
- Binomial Probability Distribution (Excel) - 1
- Binomial Probability Distribution (Excel) - 2
- Other Distributions Related to Binomial Distribution (Theory)
- Other Distributions Related to Binomial Distribution (Excel)
- Poisson Distribution (Theory)
- Poisson Distribution (Excel)
- Practice Activity - Probability Distributions - Quiz 5
Hypothesis Testing
- Section Introduction - Hypothesis Testing
- Hypothesis Testing - Types of Errors
- Hypothesis Testing Explained
- Tests for Mean, Variance and Proportions - Introduction
- One Sample z Test (Theory)
- One Sample z Test - Introduction (Excel)
- One Sample z Test - Two Tail Example (Excel)
- One Sample z Test - One Tail Example (Excel)
- Understanding the p Value (Theory)
- One Sample t Test (Theory)
- One Sample t Test - Introduction to T Functions (Excel)
- One Sample t Test - Example (Excel)
- One Sample p Test (Theory)
- One Sample p Test (Excel)
- Two Sample z Test (Theory)
- Two Sample z Test (Excel)
- Two Sample t Test (Theory)
- Two Sample t Test - Equal Variance (Theory)
- Two Sample t Test - Equal Variance (Excel)
- Two Sample t Test - Unequal Variance (Theory)
- Two Sample t Test - Unequal Variance (Excel)
- Two Sample t Test - Paired t Test (Theory)
- Two Sample t Test - Paired t Test (Excel)
- Two Sample p Test - Introduction (Theory)
- Two Sample p Test - Example (Excel)
- Tests for Variance (F and Chi Square) - Introduction
- F Test to Compare Variances
- Plotting F Distribution in Excel
- F Distribution Related Functions in Excel
- F.TEST Function in Excel
- F Test Using Data Aanalysis Pack
- Chi Square Test for Variance
- Plotting Chi Square Distribution in Excel
- Chi Square Distribution Related Functions in Excel
- Chi Square Test Example using Excel
- Practice Activity - Hypothesis Testing - Quiz 6
ANOVA - Analysis of Variance
- Section Introduction - ANOVA
- Why do you need ANOVA?
