
Learn core statistics for business and data science through data analysis, data visualization, and probability, with practical Excel guidance to turn data into informed decisions.
Discover how statistics render data into meaningful, honest stories for business and data science. Learn terminology, apply practical tools, and understand what statistics can and cannot do.
Learn how the median captures the middle value of ordered data, including odd and even cases, with formulas, Excel tips, and linear interpolation caveats for estimating age data.
Explore quantiles, range, and the interquartile range to measure data spread, including quartiles, deciles, and percentiles, with practical Excel examples and box plots.
Explore standard deviation and variance as spread measures, contrasting interquartile range intuition with mean absolute deviation and population versus sample formulas, including stdev and var.
Calculate the coefficient of variation, the standard deviation divided by the mean, to compare relative volatility across datasets like A and B and Bitcoin and Ethereum in Excel.
Explore how skew reveals the shape of a distribution, from positive to negative to no skew, and how outliers influence mean, median, and mode, and moments underpin the skew formula.
Delve into kurtosis as a measure of fat tails and the impact of outliers, contrasting datasets with identical mean and skew to reveal tail risk.
Explore how correlation measures linear association between two variables in bivariate data, using the coefficient r from -1 to 1, and note outliers, Anscombe's quartet, and data that are elliptical.
Identify anomalies and outliers in data, decide when to remove or keep them, and apply mean plus two standard deviations or median plus 1.5 interquartile ranges to set bounds.
Explore how coding data uses scaling and shifting to transform the mean and standard deviation, illustrated by Celsius–Fahrenheit conversion and the Y = aX + b formula.
Explore how line graphs visualize data and trends, including time series, axis adjustments, and pros and cons of various visualization techniques in Excel.
Learn how bar charts compare to line graphs, display multiple data series, and use stacked bars, while avoiding misleading axes by keeping the baseline zero and ensuring proper category spacing.
Explore dual axis charts to compare two data sets on one graph, such as homes sold and average price, using left and right axes in Excel for clear trend relationships.
Explore histograms for visualizing the distribution of continuous data, using area to encode frequency and frequency density (frequency divided by class width) with rectangular boxes.
Explore cumulative frequency curves to display data, read the mean and quartiles from graphs, and link to box plots; learn practical Excel steps to create and smooth the curve.
Explore how to take a random sample, using simple, systematic, and stratified techniques, with a focus on sampling frames, bias, and representativeness.
Explore the foundations of probability, from independent and mutually exclusive events to tree and Venn diagrams, then master conditional probability and Bayes' theorem from a bayesian perspective.
Explore independent events with dice and coin examples. Apply the if and only if rule P(A and B) = P(A)P(B) when outcomes are independent.
Explore how to visualize and solve probability problems using tree diagrams, with practical examples on weather and tennis decisions and on drawing two sweets to compute probabilities across branches.
Master Bayes' theorem and conditional probability with intuitive disease test examples and the idea of prior, likelihood, and posterior updates. Apply these concepts to uncertainty in business and data science.
This course is designed for those who want to apply statistics to make informed decisions in business and data science. It covers foundational concepts necessary to begin your journey in data analysis, business analytics, or any field where data is used to gain insights into the world around us. No prior experience is assumed, and all you need is basic arithmetic and a desire to learn.
I simplify statistics to make it accessible, especially if you're new to the field or haven’t applied it in a practical business or data science context. This is an ideal starting point for anyone looking to gain confidence in using statistical methods for problem-solving.
The course is practical, hands-on, and focused on showing you how to apply what you learn. Whenever possible, I'll demonstrate how to implement statistical techniques using Microsoft Excel.
Key Concepts Covered:
Descriptive Statistics – Learn essential concepts like averages, measures of spread and correlation, and more advanced metrics like skewness to analyze and interpret data.
Data Cleaning – Master techniques to handle messy data and transform it into meaningful insights.
Data Visualization – Understand the best ways to present your data visually, with step-by-step instructions on how to create effective visualizations using Excel.
Probability – Learn the core principles of probability, including conditional probability and an introduction to Bayesian statistics.
Throughout the course, I'll be available in the Q&A to answer any questions and provide guidance. I aim to support you every step of the way to ensure you get the most out of this learning experience.
I look forward to helping you discover how statistics can enhance your decision-making skills!