Analytics Stories Course
Who is Dr. Wayne Winston
and how can his Analytics
Stories Course help you?
Tutorials
0 +
Hours Of Content
0 +
Downloadable Files
0 +
Why Should You Enroll in The Analytics Stories Course?
Trusted by the most data driven companies worldwide
Get the Analytics Stories Course for Just $147

This is the complete training. 40 years of experience helping virtually all of the Fortune 500 companies through his books or in person training. 

120+ videos, 200+ downloadable files covering 15+ hours of content. Just scroll down to see what each video covers. 

Unlock Lifetime Access
to this Course

Introduction To Descriptive Statistics (8:36)
In this video we introduce descriptive statistics.

Investment Returns (6:24)
In this video we analyze annual returns on US investments.

Random Variables and Women’s Heights (12:06)
In this video we define random variables and analyze the height of American women.

1969 Draft Lottery Part One (7:07)
This video shows discusses the 1969 Vietnam Draft Lottery.

1969 Draft Lottery Part Two (7:53)
In this video we use a two sample test to show the 1969 draft lottery was not fair and the 1970 lottery was fair.

Draft Lottery Boxplots (4:39)
In this video we use Boxplots to show the 1969 lottery was unfair and 1970 lottery was fair.

Who Won: Gore or Bush? (9:59)
In this video we analyze the controversial 2000 POTUS Election.

Ponzi Schemes (7:44)
In this video we use betting predictions to show Leicester winning the Premiere League was the greatest upset of all time.

Ponzi Schemes (8:31)
This video shows how Ponzi schemes work.

Bernie’s Alleged Strategy (7:09)
This video explains Madoff’s “split strike strategy”.

Benford’s Law and Country Populations (6:04)
This video shows that 30% of all country populations begin with 1.

Why Benford’s Law Works (3:35)
This video hows how to use a simulation to show why Benford’s Law works.

Benford’s Law and Madoff Returns (8:33)
This video shows that Madoff’s made up returns violate Benford’s Law.

Sharpe Ratio for Madoff (5:35)
This video shows that Madoff’s Sharpe Ratio was suspiciously high.

The US Worker (10:14)
This video shows the lot of the typical US worker has not improved much over the last fifty years.

Measures of Income Inequality (8:20)
In this video we discuss the Gini, Palam, and Atkinson indices of inequality.

Estimating a Demand Line and the Beta of a Stock (12:57)
In this video we discuss determining the least square demand curve and estimating the Beta of Madoff’s made up returns.

RSQ, Correlations, and Regression to the Mean (15:05)
In this video we discuss why a high RSQ may not prove anything and define and discuss correlation.

The Power Curve and Elasticity (7:36)
In this video we discuss the power curve and its relationship to price elasticity.

Introduction to Intergenerational Mobility (8:14)
In this video we discuss how economists measure income mobility between generations.

Computing Rank Rank and IGE (6:47)
In this video we show how to compute IGE and Rank-Rank measures of Intergenerational mobility.

Quintiles and the Gatsby Curve (6:31)
In this video we discuss how quintiles relate to Intergenerational mobility and look at Krueger’s Gatsby Curve that relates income inequality and intergenerational mobility.

Free Lunch Percentage (9:41)
In this video we show that the fraction of students getting free lunches explains around 50% of the variation in pass rate on standardized tests.

Teacher Evaluation Based on Tests (5:42)
In this video we discuss the pros and cons of evaluating K-12 teachers based on test scores.

Common Teacher Evaluation Methods (3:54)
In this video we use Pivot Tables to illustrate simple methods for evaluating teachers based on test scores.

Simpson’s Paradox (8:26)
This video shows women are less likely to be accepted in their major than men, but in each major women are more likely to be accepted. How can this happen?

Three More Paradoxes (4:43)
In this video we resolve three more analytic paradoxes.

Is Carmelo Anthony a Hall of Famer? (12:02)
In this video we show that Manu Ginobili is more deserving than Carmelo Anthony of election to the NBA Hall of Fame.

Was Derek Jeter a Great Fielder? (10:29)
In this video we show that although he won 5 gold gloves, Derek Jeter was a below average fielder.

Golf Analytics (5:02)
In this video we introduce you to the concept of strokes gained, which has revolutionized golf.

Using Regression To Calculate NFL QB Rating (6:18)
In this video we show how to use multiple regression to reverse engineer the NFL QB rating formula.

Interpreting Multiple Regression Output (7:48)
In this video we show how to interpret multiple regression output.

Using The TREND Function To Make Predictions (4:21)
In this video we we use the TREND function to make multiple regression predictions.

Problems With NFL QB Rating (6:10)
In this video we show that the NFL QB rating has fatal flaws.

Alternatives To The NFL QB Rating (4:42)
In this video we discuss alternatives to the NFL QB rating.

Which Sports Have The Most Skill and Least Luck? (8:08)
In this video we develop a simple method for measuring the relative importance of skill and luck in team sports.

Gerrymandering (16:57)
In this video we discuss how state legislatures can draw House districts to make their congressional delegation non-representative of their state’s population.

Scurvy and Evidence Based Medicine (12:14)
In this video we discuss randomized controlled trials and evidence based medicine.

The Streptomycin Trial (5:08)
In this video we discuss the RCT that showed streptomycin is effective in treating TB.

RCT’s and Hormone Replacement (3:49)
In this video we discuss the complex issue of whether hormone replacement increases mortality.

Comparing Hospitals (9:38)
In this video we discuss some of the pitfalls involved in rating hospitals.

Using DALY’s to Compare Health Problems (7:12)
In this video we show how the DALY (Disability Adjusted Life Years) can be used to determine the importance of difference health problems in any country.

DALY Dashboards (4:42)
In this video we explore IHME’s DALY dashboards to show how different regions of the world face different health problems.

Introduction to Mutual Fund Ratings (4:26)
In this video we discuss Morningstar’s method for rating mutual funds.

The Sortino Ratio (4:56)
In this we show how the Sortino Ratio improves on the Sharpe Ratio.

Seeking Alpha (4:20)
In this video we discuss alpha, which is an important measure of investment performance.

Do Morningstar Ratings Do A Good Job Of Predicting Future Performance? (3:20)
In this video we discuss a Wall Street Journal study that shows 5 star and 1 star funds regress to the mean in future performance.

How Does The Performance Fee Affect Long-Run Investment Performance? (4:14)
In this video we show that if performance is identical, an advisor taking a 2% annual fee reduces your 30 year ending capital by 30% compared to an advisor taking a 0.1% annual fee.

Why Do NFL Bets Work? (6:06)
In this video we describe the NFL point spread, totals, and money line bets.

Evaluating Forecast (4:41)
In this video we discuss the key measures of forecast bias and accuracy.

Are Point Spreads Biased? (9:17)
In this video we show that NFL point spreads exhibit little or no bias.

Intelligence Is Key Predictor Of Job Performance (9:52)
In this video we discuss research that indicates that intelligence is the best predictor of job performance.

Ivy League Is Overrated (8:27)
In this video we show that after adjusting for student quality, researchers found Ivy League Schools do not add more value than quality state schools.

Regression To The Mean In The NFL And NBA (6:57)
In this video we show how regression to the mean explains why great teams fall to earth the next season.

Using The Inverted Yield Curve And Sahm Rule To Predict Recessions (10:40)
In this video we show how the Inverted Yield Curve and the Sahm Unemployment rate rule can be used to predict recessions.

Conditional Formatting With A Formula (5:47)
In this video we show how formulas can be used to create conditional formats.

Introduction To SPC (2:59)
In this video we explain the basics of control charts and how to tell if a process mean has shifted.

Using Control Charts To Predict The 2008 Housing Crisis (6:47)
In this video we use control charts to identify the housing price bubble and housing price collapse.

What Data Is Used By Target To Predict If A Woman Is Pregnant? (6:17)
In this video we discuss the data used to predict if a woman is pregnant and the technique of logistic regression.

More On Logistic Regression And Target (5:32)
In this video we show that for any predicted likelihood of a woman being pregnant, the logistic regression model does not exhibit much bias.

Introduction To Collaborative Filtering (5:40)
In this video we introduce the concept of collaborative filtering and give an example of user based collaborative filtering.

User Based Collaborative Filtering, The Netflix Prize And House Of Cards (6:16)
In this video we give an example of User Based Collaborative filtering and discuss the Netflix Prize competition and the reason why Netflix made House of Cards.

What Are Sensitivity, Specificity And Posterior Probability? (9:33)
In this video we define the sensitivity and specificity of a medical test.

Receiver Operator Characteristic Curve (ROC) (9:43)
In this video we discuss the construction and interpretation of the ROC curve.

Apple Heart Study (2:07)
In this video we show that the Apple Heart Study has low sensitivity.

Does Hot Spot Policing Reduce Crime? (5:04)
In this video we discuss a study that uses an RCT to show adding police reduces crime in high crime areas.

Other Police Strategies (7:34)
In this video we look at predictive policing, stop and frisk, CCTV, and broken windows approaches to policing.

A Simple Model To Predict Daily Customers (7:28)
In this video we develop a model using trend, day of week, week of year, and holidays to predict customer count at a restaurant.

Setting Up The Spreadsheet (7:29)
In this video we explain the formulas needed to create and evaluate our daily forecasts.

Using The Excel Solver (10:13)
In this video we introduce the Excel Solver and use it to find the best customer forecasts.

Which Variables Are Most Useful For Forecasting Customer Counts? (2:53)
In this video we show the day of the week and holidays are the most useful variables in creating our forecasts.

How Can Prediction Markets Be Used To Predict The Future? (7:29)
In this video we show how prediction markets provide a simple mechanism for making accurate future forecasts.

How Do Polls Work? (12:14)
In this video we discuss important concepts needed to understand polling and look at reasons why polls sometimes fail.

Why Did The Buzzfeed Dress Go Viral? (9:15)
In this video we discuss memes, social lift ,and Instagram engagement.

Taylor Swift Vs. Adele (5:23)
In this video we compare search activity for these two great performers.

Using Google Trends (11:30)
In this video we show how Google Trends can be used to predict ratings for each GOT premiere episode.

Smoking And Lung Cancer (8:08)
In this video we review the history of the debate about whether smoking cases lung cancer.

Middle School Math And The NBA (15:35)
In this video we show how the Rockets’ shot selection, not their shooting ability contributes to their great success.

Why Are Bunts And IBB’s Less Common? (5:14)
In this video we explore the reasons why in most situations bunts and intentional walks are not beneficial.

NFL Decision Making Is Flawed (8:04)
In this video we show NFL teams should pass more, go for it more on 4th down, and go for 2 more often.

John Snow The G.O.A.T Of Doctors (6:29)
In this video we show you how the great John Snow showed contaminated water caused cholera.

Summarizing Cholera Deaths with a Bubble Chart (4:36)
In this video we show how to create a bubble chart that shows the preponderance of cholera deaths near the Broad Street pump.

Predicting Painter’s Tape Sales (6:18)
In this video we develop a model to predict product sales based on quarter of the year, product on display, availability of coupons, and product price.

Using The GRG Multistart Solver Engine (5:38)
In this video we show how to use the GRG multistart engine to fit complex forecasting models.

The Pareto Principle And Power Laws (6:00)
In this video we show how power laws lead to the 80-20 rule.

The Long Tail And Power Law For Income (6:49)
In this video we explain how 10% of all book titles can generate 84% of all sales and how power laws explain the Pareto distribution of income.

Rich Get Richer And Websites (8:27)
In this video we show how the rich get richer theory explains how few websites dominate the Internet.

Cook County Vs. Dupage County (6:53)
In this video we explore how moving a low income child to a better neighborhood can give them a better chance at success.

Analyzing Waiting Lines (10:08)
In this video we show how to determine the average time and number of people in a queueing system.

Data Tables And Queuing (5:36)
In this video we use data tables to perform a sensitivity analysis on a queueing system.

Why Do Roundabouts Work? (7:34)
In this video we discuss the pros and cons of roundabouts.

How Do Ramp Meters Work? (5:39)
In this video we discuss how ramp meters improve freeway traffic performance.

Reducing K-12 Class Size (8:32)
In this video we discuss how reducing K-2 class size improves test scores.

Cost Benefit Analysis (4:56)
In this video we estimate a 9.8% annual rate of return on reduced K-12 class size.

A/B Testing (9:03)
In this video we describe A/B testing, which is used to improve performance of websites and Facebook Ads.

Introduction To Portfolio Optimization (6:59)
In this video we discuss how to trade off risk vs. return when determining your portfolio’s asset allocation.

Solver Portfolio Optimization (9:07)
In this video we work through an asset allocation with the Excel Solver.

Introduction To Hedge Funds (6:56)
In this video we discuss long, short, and market neutral hedge funds.

Convertible Bond And Merger Arbitrage (7:11)
In this video we discuss convertible bond and merger arbitrage strategies.

Global Macro And Worst Case Strategies (6:00)
In this video we discuss Global Macro strategies and a portfolio optimization approach that maximizes the worst case return.

How Much Should We Order? (8:04)
In this video we discuss the economic order quantity (EOQ) that tells you the cost minimizing order quantity.

When Should We Order? (5:29)
In this video we discuss how to use the service level approach to determine how low to let inventory go before you reorder.

The Traveling Salesperson Problem (TSP) (6:14)
In this video we discuss the problem of visiting a list of cities once and returning home and traveling the least distance.

Using The Solver To Solve The TSP (6:04)
In this video we use the “All Different” feature of the Solver to solve a TSP.

Obama And Trump’s Use Of Analytics (7:24)
In this video we discuss how analytics was a key factor in the 2012 and 2016 Presidential elections.

Solver And Logistic Regression (10:13)
In this video we show how to use the Solver and logistic regression to estimate the probability a voter is a Democrat.

How To Pick A Winner (9:52)
In this video we show it is really hard to find a rule that is good for choosing the winner in an election.

Approval Voting And Quadratic Voting (5:29)
In this video we describe Approval and Quadratic voting.

The Winner’s Curse (4:10)
In this video we discuss why people overpay when bidding for things.

Avoiding The Winner’s Curse (3:57)
In this video we use simulation to show how to adjust a bid to avoid the winner’s curse.

Can Analytics Recognize, Predict, Or Write A Hit Song? (8:34)
In this video we discuss how Shazam works, how Norah Jones’ debut album was sure to be a smash hit, and how computers try and write songs.

How Are Algorithms Used In Parole Decisions? (9:22)
In this video we discuss the problem of disparate impact when algorithms are used in parole decisions.

ProPublica And Parole Bias (3:36)
In this video we give an introduction to AI and show how it can improve parole decisions.

AI And Parole Decisions (8:55)
In this video we introduce you to the concept of strokes gained, which has revolutionized golf.

The Shift (6:42)
In this video we show how the baseball shift kills left-hand hitters.

Rating Players And Lineups (10:26)
In this video we show how analytics gave the Dallas Mavericks and New York Knicks an edge in the NBA.

How Can We Fairly Resolve Conflict Among Two Parties? (6:34)
In this video we show how the Excel Solver can come up with an optimal division of property in a divorce.

Explaining the SIR Epidemic Model (10:44)
In this video we explain how the basic SIR model shows us how tragically 1 case of a disease can eventually infect the entire population.

Explaining The SEIRS Epidemic Model (9:23)
In this video we generalize the SIR model to allow for people to be exposed before they become infected, lose immunity, and die from the virus.

Using PivotTables To Summarize COVID-19 data (11:58)
In this video we show how to use PivotTables to chart daily COVID -19 cases by state and 7 day moving average of deaths, by state.

Covid 19 Around The World (6:19)
In this video we show how to create a chart that compares the course of daily COVID-19 cases per 100,000 people in any set of countries.

Mail-In Voting (11:13)
In this video we show that even if Biden leads in the popular vote, there is a good chance he will be behind on November 4th because many more Biden voters plan to vote by mail than Trump voters. We build a model that shows that even if Biden voters outnumber Trump voters by 8%, there is a reasonable chance that Trump will be ahead the day after election day.

Polling (1:28)
In this video we discuss why the polls messed up so badly in the 2020 election.

Vaccine Efficacy (7:29)
In this video we explain the math behind Pfizer’s claim that their vaccine was 90% effective.

Unlock Lifetime Access
Billing detail
[ cartflows_checkout ]

$147 / lifetime access

Best Course I've Taken

5/5

Best professor I’ve ever had. I’d take him for anything and think he could teach anything, but Decision modeling in spreadsheets was the best, most relevant (for a finance major like me at least) class I had as an MBA student. Hope you are well Professor Winston!

Todd Williams

Perfect Course!

5/5

I’m on day 4 and already feeling more knowledgeable and empowered!

Jeff Skirvin

Amazing & Useful Content

5/5

I’ve enjoyed the training very much. I’ve been using excel for many years, but with Wayne’s training, I’ve been able to do things quicker which saves me time and allows me to complete my projects faster. I recommend this training. It’s awesome. Thanks Wayne.

Luis Arroyo

Frequently asked questions
Is there a Money Back guarantee?

Yes! If you finish at least 50% of the course within the first 60 days and aren't 100% satisfied, we will issue a 100% money back gaurantee, no questions asked.

How long will I have access to the course?

How does forever sound? All of our courses offer lifetime access. So just invest in yourself once, and have the course forever.

Are the files included in the course?

Yes! Once you enroll, you can download any of the more than 200+ files. The before and after files are included in the course which will help you be able to easily follow along. Please note that the videos can not be downloaded.

Can I make monthly payments?

Currently we only have lifetime plans.

How up to date is the course?

This course teaches how to answer real world issues using the most up to date Excel features and functionality. Scroll down just a bit to see exactly what is covered in the course to see if it is a good fir for you!

Is this course right for me?

This course is a fun course that answers real world problems. It’s a bit different than the others in the sense Dr. Winston shows through advanced Excel techniques, how to answer real world problems. If you have experience with Excel and are looking to answer real world problems, then this is the course for you. This course was modeled off of Dr. Winston’s Analytics Stories book (you can see the reviews on Amazon, but it currently has 4.8 stars with dozens of reviews.