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

⚖️

Model Selection

Choose between models without fooling yourself — and know what you spent every time you looked at the data.

8 lessons · 102 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

🧹

Data Preparation for Mining

Everything you do to a table before a model touches it — and what each of those choices costs.

8 lessons · 87 min · Intermediate

Start

🧭

Principal Component Analysis

Find the few directions your many correlated columns are really moving in — and know when that idea breaks.

8 lessons · 89 min · Advanced

Start

🎯

k-Means Clustering

Split rows into groups nobody labelled — and control every decision that silently determines which groups you get.

8 lessons · 88 min · Advanced

Start

🌲

Hierarchical Clustering

Build the whole family tree of your data, then decide for yourself where to cut it.

8 lessons · 92 min · Advanced

Start

🎯

k-Nearest Neighbours and Naive Bayes

Two classifiers with no model to fit: one remembers every case, the other counts.

8 lessons · 90 min · Advanced

Start

🌳

Decision Trees

A model you can read aloud — and the one that changes its mind if you change three rows.

8 lessons · 91 min · Advanced

Start

🛒

Association Rules

Find the items that really travel together, and reject the pairs that only look like they do.

8 lessons · 84 min · Advanced

Start

🎯

Model Evaluation

Decide whether a classifier is any good — and be precise about what you are comparing it to.

8 lessons · 90 min · Advanced

Start

🎲

Simulation and the Bootstrap

Answer the questions that have no formula by generating the data instead.

8 lessons · 87 min · Advanced

Start

🧪

Experimental Design

Plan the test before it runs: randomisation, sample size, blocking, and the traps that turn noise into a decision.

8 lessons · 91 min · Advanced

Start

⏳

Survival Analysis

Time-to-event data done properly: censoring, Kaplan-Meier by hand, the log-rank test and hazard ratios.

8 lessons · 94 min · Advanced

Start

🏁

Capstone Project

One project from end to end: frame the question, prepare the data, choose the method, validate it, and report it honestly.

8 lessons · 95 min · Advanced

Start