Statistics with Excel, zero to expert

🧱

Data Foundations

Get your data into the shape every statistical method silently assumes.

8 lessons · 80 min · Beginner

Start

📊

Descriptive Statistics

Summarise a column so that the number you report is the number you mean.

8 lessons · 83 min · Beginner

Start

🎲

Probability and Distributions

Turn a column of outcomes into probabilities, and know which curve you are entitled to use.

8 lessons · 85 min · Beginner

Start

🎯

Sampling and the Central Limit Theorem

Why forty measurements can speak for forty thousand — and the conditions under which they cannot.

8 lessons · 74 min · Beginner

Start

📏

Confidence Intervals

What an interval estimate actually claims, what it never claims, and how to build one in Excel.

8 lessons · 72 min · Intermediate

Start

⚖️

Hypothesis Testing

What a p-value measures, what it cannot measure, and how to run a test you can defend.

8 lessons · 74 min · Intermediate

Start

⚖️

t-Tests

Decide whether a difference in means is bigger than the noise — and know which of the three tests you are entitled to use.

8 lessons · 92 min · Intermediate

Start

🧮

ANOVA

Compare three or more groups in one test, and find out where the difference lives without inventing significance.

8 lessons · 94 min · Intermediate

Start

🔲

Chi-Square Tests

Test counts instead of means: does this distribution match what you expected, and are these two categories related?

8 lessons · 93 min · Intermediate

Start

🪜

Nonparametric Tests

Test differences with ranks when the mean is the wrong summary — and build every statistic by hand, because Excel has none of them.

8 lessons · 85 min · Intermediate

Start

🔗

Correlation

Measure how two columns move together, test whether it is real, and learn everything r refuses to tell you.

8 lessons · 85 min · Intermediate

Start

📈

Simple Regression

Fit one line to two columns, say precisely what its slope means, and know how far to trust the number it predicts.

8 lessons · 85 min · Intermediate

Start

📐

Multiple Regression

Estimate the effect of one variable while the others are held still — and know exactly what that sentence buys you.

8 lessons · 99 min · Advanced

Start

🩺

Regression Diagnostics

Interrogate a fitted model until it either earns your trust or admits what it is hiding.

8 lessons · 101 min · Advanced

Start

🎯

Logistic Regression

Model a yes/no outcome properly: odds, log-odds, maximum likelihood and Solver.

8 lessons · 87 min · Advanced

Start

📈

Time Series Basics

Trend, season and noise — and why the order of the rows changes every rule you know.

8 lessons · 85 min · Intermediate

Start

🔮

Forecasting

Holt-Winters, Excel's ETS tools, error measures — and the naive forecast you have to beat.

8 lessons · 85 min · Intermediate

Start