Welcome · Start here
Welcome to the course: what you will learn
Learn it with your tutor on the live board
Key points from the video
From gut feel to confident answers
- A new checkout page went live last month
- Average order value went up a little
- Real change, or normal noise?
- Your manager wants a clear answer by Friday
Who this is for
- Analysts, marketers and managers who live in Excel
- You make decisions from orders, surveys and tests
- You need comfort with spreadsheets and basic Python
- No advanced math needed: every term explained
How the course fits together
- Two tracks, eight courses
- Track one: describe and understand data
- Track two: test ideas and find relationships
- Each step builds on the one before
Track 1: Describing and Understanding Data
- Data Foundations with Pandas
- Describing Data: Center and Spread
- Visualizing Distributions
- Probability and Distributions in Plain Words
Track 2: Testing Ideas and Relationships
- Sampling and Uncertainty
- Hypothesis Testing Without Fear
- A/B Testing in Practice
- Relationships: Correlation and Regression
Projects you will build
- A clean orders dataset answering three business questions
- Outliers flagged in support ticket resolution times
- Expected revenue from a promotion
- A tested checkout page and an A/B test recommendation
- Ticket volume predicted from orders to plan staffing
How to get the most out of it
- Steady pace: a few lessons a week beats one long binge
- Run every example yourself and change the numbers
- Finish each project before moving on
- Try each method on your own work data
Recap and what comes next
- Track 1: clean, describe, chart, and reason about chance
- Track 2: estimate, test, run A/B tests, and model relationships
- Eight hands-on projects from a real online shop
- Next: Why statistics matters for everyday decisions
Transcript
From gut feel to confident answers. Welcome to Practical Statistics for Everyday Decisions course. Picture this. You work on the analytics for an online shop, and last month the team launched a new checkout page. Average order value went up a little. So was that the new page, or just the normal ups and downs from one week to the next? Your manager wants a yes or a no by Friday. Many of us would look at a chart and go with gut feel. By the end, you'll answer questions like this with numbers. You'll also be able to say how sure you are and explain it in plain words to the people who have to act on it. That's what Practical Statistics for Everyday Decisions is about.
Who this is for. This is for analysts, marketers and managers who already work in Excel and want to trust the decisions they make from data. You don't need a statistics degree. If you can read a spreadsheet and run a short Python snippet, you're ready. We'll use pandas, a Python library that works like a spreadsheet you control with code, and we'll build it up from the very first lesson. Every statistics term gets a plain explanation the first time it shows up, usually with an example from the online shop: orders, customer surveys, website A/B tests and support ticket times.
How the course fits together. The course has two tracks with eight courses in total. The first track, Describing and Understanding Data, teaches you to clean data, summarize it, chart it and reason about chance. The second track, Testing Ideas and Finding Relationships, uses those skills to answer harder questions. Did a change really make a difference? How do two numbers move together? Each piece relies on the one before it. You can't judge whether a difference is real until you can describe your data and understand how much it wobbles by chance. That's why we go in this order.
Track 1: Describing and Understanding Data. Track one starts with Data Foundations with Pandas: loading order data, fixing missing values and duplicates, and grouping to get quick business answers. In Describing Data: Center and Spread, you'll learn when the median, the middle value, tells the truth better than the mean. You'll also meet standard deviation, which measures how far values usually sit from the average. Visualizing Distributions covers histograms and choosing the right chart. Probability and Distributions in Plain Words covers the bell curve and expected value, the average result you'd get over many tries. Afterwards, you'll clean, summarize and chart shop data with confidence.
Track 2: Testing Ideas and Relationships. Track two turns description into decisions. Sampling and Uncertainty explains confidence intervals: a range that likely holds the true value, like a forecast of fifteen to eighteen degrees. Hypothesis Testing Without Fear explains p-values, which tell you how surprising your result would be if nothing had really changed. You'll also learn the traps, like testing so many things that something looks significant by luck. A/B Testing in Practice covers fair test design and reading conversion results. Relationships: Correlation and Regression shows you how to fit a line between two numbers and why correlation isn't causation.
Projects you will build. Every course ends with a project based on the online shop. You'll build a clean orders dataset and use it to answer three business questions. You'll describe support ticket resolution times and flag the unusual ones. You'll compare order values across customer segments and estimate expected revenue from a promotion. Then you'll put a confidence interval around average order value and test whether the new checkout page changed it. You'll analyze a website A/B test and recommend a decision. Finally, you'll predict support ticket volume from orders and use that prediction to decide staffing.
How to get the most out of it. A few tips. Keep a steady pace. A few lessons a week sticks much better than one long weekend. Run each example yourself and change the numbers to see what happens, because that's where the ideas start to make sense. Please don't skip the projects. They're where the separate lessons come together into something you could show your manager. And whenever you can, try the method on your own data, like last quarter's orders or your team's survey results. Real data you care about is the best practice there is.
Recap and what comes next. That's the plan for Practical Statistics for Everyday Decisions. In track one, you'll learn to clean, describe and chart your data and to think clearly about chance. In track two, you'll estimate with honest uncertainty, test ideas, run fair A/B tests and model relationships between numbers. Along the way, you'll complete eight practical projects from an online shop. Next up is the first course, Data Foundations with Pandas, starting with a lesson on why statistics matters for everyday decisions and how to move from gut feel to numbers. See you there.
Lesson summary
- Video watched
- Track 1: clean, describe, chart, and reason about chance
- Track 2: estimate, test, run A/B tests, and model relationships
- Eight hands-on projects from a real online shop
- Next: Why statistics matters for everyday decisions