Analytics Stories

From Data to Decisions: Statistics, Probability & Risk Analysis in Excel 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction to Descriptive Statistics: Understanding Data in Excel

From Data to Decisions: Stock Market Trends & Risk Analysis

Mastering Probability Distributions: Normal Curves & Random Variables

Was the 1969 Draft Lottery Rigged? Data Analysis & Visualization in Excel 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

The 1969 Vietnam Draft Lottery: Was It Really Fair?

The 1969 Draft Lottery: Statistical Proof It Wasn’t Random?

Boxplots & Bias: Visualizing the 1969 Draft Lottery

Election Data Analytics: Uncovering Trends & Bias in the 2000 Presidential Race 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Ranking the Biggest Upsets in Sports History

The Greatest Underdog Victories: Analyzing Sports Upsets with Excel 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Ranking the Biggest Upsets in Sports History

The Madoff Case Study: Benford’s Law, Fraud Analysis & Market Manipulation 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

How to Model a Ponzi Scheme: The Bernie Madoff Case Study

Bernie Madoff’s Alleged Strategy: How the Split-Strike Scheme Fooled Investors

From Population Data to Fraud Detection: Benford’s Law Explained

Why Benford’s Law Works: The Math Behind Real-World Numbers

How Benford’s Law Exposed Bernie Madoff’s Fraudulent Returns

Data Science: Why Madoff’s Returns Were Too Good to Be True

Income Stagnation vs. Economic Growth: The Reality of U.S. Wages Over 50 Years 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The American Worker: Has Income Really Improved Over the Last 50 Years?

Income Inequality & Wealth Gaps: Data-Driven Insights with Excel 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Measures of Income Inequality

Predicting Demand & Market Sensitivity: Regression & Analytics in Excel 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Data Analytics: Predicting Demand & Stock Market Sensitivity

R-Squared, Correlation & Regression to the Mean: What They Really Mean

Understanding the Power Curve & Elasticity: Analyzing Non-Linear Demand

Intergenerational Mobility: Measuring Economic Opportunity Across Generations 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Intergenerational Mobility: Can Kids Really Do Better Than Their Parents?

From Poverty to Prosperity: The Data Behind Economic Mobility

Mastering Wealth Mobility: Understanding Quintiles & The Gatsby Curve

How Income Predicts Education: Regression Analysis of Student Performance 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Mastering Regression Analysis: How Economic Status Predicts Student Achievement

Evaluating Teachers with Data: The Accuracy & Limitations of Test Scores 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Evaluating Teachers with Test Scores: Does It Really Work?

Data Analytics in Excel: Comparing Teacher Evaluation Methods

When Data Lies: Simpson’s Paradox & Other Surprising Analytical Pitfalls 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

From Admissions Data to Business Decisions: Understanding Simpson’s Paradox

Three Fascinating Paradoxes in Analytics: When Data Defies Expectations

Beyond Points Per Game: How Data Analytics Evaluates NBA Legends 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Mastering Basketball Analytics: How Advanced Metrics Evaluate NBA Greats

Mastering Baseball Analytics: Evaluating Defense with Advanced Metrics 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

From Fielding Percentage to Ultimate Zone Rating: Understanding Baseball Defense Metrics

Strokes Gained & Golf Analytics: What Really Wins Tournaments? 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Golf Analytics: Why “Drive for Show, Putt for Dough” Is a Myth

Mastering Quarterback Analytics: Why NFL Passer Rating Falls Short 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Mastering Quarterback Analytics: Why NFL Passer Rating Falls Short

How to Use Excel to Evaluate Regression Models & Make Better Predictions

Using the TREND Function: Predicting NFL QB Ratings

Mastering QB Analytics: Why the NFL Passer Rating Doesn’t Make Sense

A Better Way to Rank NFL Quarterbacks: Points Per Play & Advanced Metrics

The Role of Skill in Sports: Which Leagues Reward Talent the Most? 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

From the NBA to the NFL: Which Sports Are Most Driven by Skill?

The Power of District Maps: How Excel Helps Uncover Gerrymandering Tactics 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Gerrymandering: How Politicians Manipulate Elections with District Maps

The History of Evidence-Based Medicine: Scury, Tuberculosis, & HRT Studies 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

How a 1700s Scurvy Experiment Revolutionized Modern Medicine

Mastering Medical Analytics: How a 1946 Tuberculosis Trial Changed Medicine

Data-Driven Medicine: What We’ve Learned About Hormone Therapy Since 1991

Unveiling Hospital Rankings: Analyzing Patient Risk and Healthcare Metrics 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Mastering Healthcare Analytics: Are Hospital Rankings Misleading?

Global Health Metrics: Using DALYs to Measure the Impact of Diseases Across Regions 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Data-Driven Healthcare: Ranking the Most Serious Health Issues

How Different Regions of the World Experience Health Problems Differently

Mastering Investment Analytics: Risk, Performance & Fee Impact Analysis 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Mastering Investment Analytics: Do Mutual Fund Ratings Predict Performance?

Mastering Risk Analytics: Why the Sortino Ratio Beats the Sharpe Ratio

How to Use Excel to Analyze Mutual Fund Performance with Beta & Alpha

Mastering Investment Analytics: The Truth About Morningstar’s Star Ratings

How Investment Fees Impact Your Wealth

Inside Sports Betting: How Vegas Sets NFL Lines & Predicts Outcomes 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

NFL Betting Explained: How Vegas Always Wins

Evaluating Forecasts: Accuracy, Bias & Prediction Errors

Las Vegas Betting Lines: Do They Favor Home Teams?

Unlocking Hiring Insights: How Data Predicts Top Employee Performance 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

What Makes a Great Employee? Data-Driven Hiring Insights

The Ivy League Debate: Does an Elite Education Really Impact Success? 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Does an Ivy League Education Really Matter? The Surprising Data

Regression to the Mean: Why Dominant Sports Teams Rarely Stay on Top 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Will Your Favorite Team Be Good Next Year? The Math Says No

Economic Forecasting: Understanding Recessions, Housing Bubbles & Process Control 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Could We Have Predicted the 2008 Crash? The Data Says Yes

Mastering Conditional Formatting: Using Formulas for Dynamic Insights

Introduction to Statistical Process Control: How to Detect Trends & Anomalies

The Data Behind the Housing Bubble: What We Could Have Seen Coming

Predicting Consumer Behavior: How Target Uses Data to Reveal Personal Insights 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Can Your Purchases Reveal Personal Secrets? Target’s Predictive Analytics Explained

Predicting Customer Behavior: The Data Model Behind Target’s Pregnancy Strategy

Collaborative Filtering in Action: How Netflix & Amazon Know Your Preferences 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Netflix and Amazon Know What You Want to Watch—Before You Do

How Netflix’s Data Science Revolutionized Streaming: Collaborative Filtering Explained

Health Tech & Accuracy: Analyzing Apple Watch’s AFib Detection with Sensitivity & Specificity 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Receiver Operating Characteristic (ROC) Curve Explained in Simple Terms

Can a Smartwatch Save Your Life? Analyzing AFib Detection with the Apple Watch

The Effectiveness of Policing Strategies: Analyzing Crime Reduction with Data 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

The Minneapolis Experiment: Does Adding More Police Lower Crime Rates?

Do Predictive Policing, CCTV, and Stop-and-Frisk Actually Reduce Crime?

Mastering Sales Forecasting: Data-Driven Models & Demand Prediction 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Predicting Daily Sales: A Data-Driven Approach

How to Set Up an Excel Spreadsheet for Accurate Demand Forecasting

How to Use Excel Solver to Build an Accurate Forecast Model

Which Variables Matter Most in Forecasting Customer Counts?

The Power of Data: Using Collective Intelligence to Predict Elections, Stocks & Sales 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Can We Predict Elections, Stock Prices, and Sales? The Data Says Yes

The Truth Behind Political Polls: Small Sample Sizes & Big Predictions 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

How Do Political Polls Really Work? The Truth About Election Forecasts

Data-Driven Virality: How Buzzfeed Predicted “The Dress” Would Break the Internet 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

How Buzzfeed Predicted The Dress Would Go Viral—Using Data

Data-Driven Music & TV Trends: Using Google Trends to Forecast Popularity 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Google Trends Predicts Music Trends: The Case of Taylor Swift & Adele

Predicting TV Ratings with Data: The Game of Thrones Experiment

Smoking and Lung Cancer: How Data Proven Probability Models Changed Public Health 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

How We Proved Smoking Causes Lung Cancer—The Data Behind the Discovery

The Analytics of Basketball: How the Rockets Optimized Shot Selection with Data 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The Analytics Behind the Rockets’ Success: Three-Pointers & Layups

Baseball Strategy Revolution: The Data Behind the Decline of Bunts & Walks 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The Analytics Behind MLB’s Shift Away from Bunts and Intentional Walks

The Data Behind NFL Play Calling: Why Passing & Aggressive Plays Lead to Wins 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The Analytics Behind NFL Play Calling: Why Teams Should Pass More

From Crisis to Cure: How Data and Maps Transformed Public Health During the Cholera Outbreak 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

The Man Who Stopped Cholera—With Data and a Map

How Bubble Charts Helped Solve the Cholera Outbreak of 1854

Retail Sales Forecasting: Using Data and Solver to Optimize Pricing & Promotions 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Building a Sales Forecast Model for Retail Products

Optimizing Sales Predictions with Excel’s GRG Multistart Solver

From the 80/20 Rule to Power Laws: Understanding Market and Business Dynamics 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

The Pareto Principle in Action: How 20% Drives 80% of Results

The Long Tail & Power Laws: Why a Few Dominate the Many

Why the Rich Get Richer: The Data Behind Market Domination

The Geography of Opportunity: How Neighborhoods Influence Future Income 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Does Where You Grow Up Shape Your Future? The Data Says Yes

Reducing Wait Times: How Queuing Theory and Data Models Improve Service Efficiency 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Businesses Reduce Wait Times Using Data & Excel Models

Queuing Theory & Sensitivity Analysis: Making Smarter Business Decisions

Roundabouts vs. Traffic Lights: A Data-Driven Comparison for Better Traffic Flow 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Are Roundabouts Better Than Traffic Lights? The Surprising Answer

Traffic Optimization: How Ramp Meters Use Data to Reduce Congestion 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Do Ramp Meters Really Help? The Surprising Data on Traffic Efficiency

Cost-Benefit Analysis of Smaller Classes: The Data Behind Education Investments 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Cutting Class Sizes Impacts Test Scores, Salaries & Crime Rates

Is Reducing Class Sizes a Smart Investment? The Cost-Benefit Breakdown

A/B Testing for Success: Using Data to Improve Website Conversions and Ad Performance 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

A/B Testing Explained: How to Optimize Websites & Ads with Data

Mastering Portfolio Optimization: Balancing Risk & Return 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Portfolio Optimization: Maximizing Returns & Minimizing Risk

How to Use Excel Solver for Portfolio Optimization & Risk Management

Hedge Funds Uncovered: Diversification, Arbitrage, & Global Macro with Data 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Hedge Funds Explained: How the Best Investors Beat the Market

How Investors Use Arbitrage to Lock in Returns & Reduce Risk

Global Macro Hedge Funds & the All-Weather Portfolio Explained

Data-Driven Inventory Optimization: How Target & Walmart Use Analytics to Reduce Costs 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Target & Walmart Optimize Inventory Using Data

Optimizing Your Reorder Point: How to Avoid Stockouts & Cut Costs

How Does The UPS Driver Know The Order To Deliver Packages? 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

The Traveling Salesperson Problem: Finding the Shortest Route

Solving the Traveling Salesperson Problem with Excel Solver: Finding the Shortest Path

Voter Targeting & Data Science: How Campaigns Use Predictive Models to Win Elections 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Obama vs. Trump: The Role of Facebook, A/B Testing & Predictive Models

Predicting Outcomes with Logistic Regression & Solver

Understanding Voting Systems: How Data Shapes Elections & Decision-Making 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How Voting Systems Shape Elections: The Data Behind Picking a Winner

Quadratic Voting: The Future of Decision-Making?

The Winner’s Curse: Why High Bids Lead to Overpayment & How to Avoid It 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

The Winner’s Curse: Why the Highest Bidder Usually Overpays

Avoiding the Winner’s Curse: How to Make Smarter Bids

Predicting Hit Songs: The Power of Data & Music Analytics 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Can Data Predict Hit Songs? The Science Behind Music Analytics

The Truth Behind Parole Algorithms: Analyzing Data Bias and Predictive Models 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

The Math of Freedom: How Data Determines Who Stays in Prison

The Truth About Parole Algorithms: Bias or Data Misinterpretation?

AI in Parole Decisions: Can Machine Learning Predict Crime?

The Shift in Baseball: How Data Revolutionized Defense & the Game Itself 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

How Data Revolutionized Baseball Defense: The Power of the Shift

Measuring Greatness: How Data and Advanced Stats Reshaped NBA Player Analysis 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The Data Behind NBA Greats: How Advanced Stats Changed Basketball

Divorce & Disputes: The Power of Data in Achieving Win-Win Solutions 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Divorce, Disputes & Data: Using Analytics to Divide Assets Fairly

The Math of Pandemics: Understanding Models & Trends in COVID-19 Data 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

The Math Behind COVID-19: How the SIR Model Works

How the SEIRS Model Helps Predict Second and Third Waves of Disease

Tracking COVID-19 Cases, Deaths & Hospitalizations Using PivotTables

Analyzing COVID-19 Trends Worldwide Using PivotTables

Mail-In Voting & Election Accuracy: How Late Ballots Impact Results Over Time 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

The Impact of Late Mail-In Votes: What History Tells Us

The Data Behind Elections & Vaccines: How COVID-19 Influenced Polling and Efficacy Calculations 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

How GOP Turnout & Hispanic Voters Broke the Polling Models

The Math Behind COVID-19 Vaccines: How Efficacy Is Calculated

Course Content

About Instructor

Wayne Winston

Course Includes

CONTACT INFO

CONTACT INFO