Before you start...-Course Overview
All you will learn
()
Suggested Textbooks (Not Required)
Module 1-Part 1 Introduction
Download Excel Files (Important!)
1.1 Introduction
()
Module 1-Part 2 Pythagorean Theorem
Excel Files
Recommended reading
1.2 Pythagorean Theorem
()
Module 1-Part 3 Ten runs = One win
Excel file
Recommended reading
1.3 Ten runs = One win
()
Module 1-Homework Problems 1 and 2
Homework Problems 1 and 2
()
Excel file
Module 1-Part 4 Runs Created
Excel file
Recommended reading
1.4 Runs created
()
Module 1-Part 5 Runs Created Per Game
Excel Files
Recommended reading
1.5 Runs Created Per Game
()
Module 1-Homework Problems 3
Homework Problem 3
Module 1-Part 6 Multiple Regression 1
Excel Files
Recommended reading
1.6 Multiple Regression 1
()
Module 1-Part 7 Multiple Regression 2
Excel Files
Recommended reading
1.7 Multiple Regression 2
()
Module 1-Part 8 Linear Weights
Excel Files
Recommended reading
1.8 Linear Weights
()
Module 1-Part 9 On Base Percentage + Slugging Percentage (OPS)
Excel Files
Recommended reading
1.9 On Base Percentage + Slugging Percentage
()
Module 1-Part 10 Barry Bonds Runs per Game
Excel Files
Recommended reading
1.10 Barry Bonds Runs per Game
()
Module 1-Homework Problems 4
Homework Problems 4
Module 2-Part 1 Excel Range Names
Download Excel Files (Important!)
Excel Files
Recommended Reading
2.1 Excel Range Names
()
Module 2-Part 2 Excel Tables
Excel Files
Recommended Reading
2.2 Excel Tables
()
Module 2-Part 3 Conditional Formatting: Top Bottom Rules and Highlight Cells
Excel Files
Recommended Reading
2.3 Conditional Formatting: Top Bottom Rules
()
Module 2-Part 4 Conditional Formatting: Data Bars, Color Scales and Icon sets
Excel Files
Recommended Reading
2.4 Conditional Formatting: Data Bars
()
Module 2-Part 5 Conditional Formatting: The Formula Option
Excel Files
Recommended Reading
2.5 Conditional Formatting: The Formula Option
()
Module 2-Part 6 COUNTIF and COUNTIFS functions and Remove Duplicates
Excel Files
Recommended Reading
2.6 COUNTIF and COUNTIFS functions
()
Module 2-Part 7 SUMIF and SUMIFS Functions
Excel Files
Recommended Reading
2.7 SUMIF and SUMIFS Functions
()
Module 2-Part 8 AVERAGEIF and AVERAGEIFS Functions
Excel Files
Recommended Reading
2.8 AVERAGEIF and AVERAGEIFS Functions
()
Module 2-Homework Problem 5
Homework Problem 5
Module 2-Part 9 Pivot Tables I
Excel Files
Recommended Reading
2.9 PivotTables I
()
Module 2-Part 10 Pivot Tables II
Excel Files
Recommended Reading
2.10 PivotTables II
()
Module 2-Homework Problem 6
Homework Problem 6
Module 3-Part 1 Monte Carlo Simulation I
Download Excel Files (Important!)
Excel Files
Recommended Reading
3.1 Monte Carlo Simulation I
()
Module 3-Part 2 Monte Carlo Simulation Part II
Excel Files
3.2 Monte Carlo Simulation Part II
()
Module 3-Part 3 Monte Carlo Simulation Part III
Excel Files
3.3 Monte Carlo Simulation Part III
()
Module 3-Part 4 Baseball Monte Carlo simulation
Excel Files
3.4 Baseball Monte Carlo simulation
()
Module 3-Part 5 Resampling
Excel Files
Recommended Reading
3.5 Resampling
()
Module 3-Part 6 Deflategate
Excel Files
3.6 Deflategate
()
Module 3-Homework Problem 8
Homework Problem 8
Module 4-Part 1 Bunting and Expected Runs
Download Excel Files (Important!)
Excel Files
Recommended Reading
4.1 Bunting and Expected Runs
()
Module 4-Part 2 Base Stealing
Excel Files
Recommended reading
4.2 Base Stealing
()
Module 4-Homework Problem 9
Homework Problem 9
Module 4-Part 3 Range Factor
Excel Files
Recommended Reading
4.3 Range Factor
()
Module 4-Part 4 UZR (Ultimate Zone Rating) and Fielding
Excel Files
4.4 UZR (Ultimate Zone Rating) and Fielding
()
Module 4-Homework Problem 10
Homework Problem 10
Module 4-Homework Problem 11
Homework Problem 11
Module 4-Part 5 Introduction to Fan Graphs
4.5 Introduction to Fan Graphs
()
Module 4-Part 6 DIPS (Defense Independent Pitching Statistics)
Excel Files
Recommended Reading
4.6 DIPS (Defense Independent Pitching Statistics)
()
Module 4-Homework Problem 12
Homework Problem 12
Module 4-Part 7 Win Probability Added
Excel Files
Recommended Reading
4.7 Win Probability Added
()
Module 4-Part 8 Runs Above Average
Excel Files
Recommended Reading
4.8 Runs above Average
()
Module 4-Part 9 WAR (Wins Above Replacement)
Excel Files
Recommended Reading
4.9 WAR (Wins above Replacement)
()
Module 4-Homework Problem 13
Homework Problem 13
Module 4-Part 10 How to Make Your Team Win?
Excel Files
4.10 What Makes your Team Win?
()
Module 4-Part 11 Defensive Shifts
Excel Files
4.11 Defensive Shifts
()
Module 4-Part 12 Catcher Framing
Excel Files
4.12 Catcher Framing
()
Module 4-Part 13 Park Factors
Excel Files
Recommended Reading
4.13 Park Factors
()
Module 4-Homework Problem 14
Homework Problem 14
Module 5-Part 1 Random Variables
Download Excel Files (Important!)
Excel Files
Recommended Reading
5.1 Random Variables
()
Module 5-Part 2 The Normal Random Variable
Excel Files
Recommended Reading
5.2 The Normal Random Variable
()
Module 5-Part 3 Streakiness
Excel Files
Recommended Reading
5.3 Streakiness
()
Module 5-Part 4 What makes NFL teams win?
Excel Files
5.4 What makes NFL teams win?
()
Module 5-Homework Problem 15
Homework Problem 15
Module 5-Part 5 Deconstructing the NFL QB rating
Excel Files
5.5 Deconstructing the NFL QB rating
()
Module 5-Homework Problem 16
Homework Problem 16
Module 5-Part 6 Football States and Values
Excel Files
Recommended Reading
5.6 Football States and Values
()
Module 5-Part 7 Football Decision Making
Excel Files
Recommended Reading
5.7 Football Decision Making
()
Module 5-Homework Problem 17
Homework Problem 17
Module 5-Part 8 The Belichick Decision
Excel Files
5.8 The Belichick Decision
()
Module 5-Homework Problem 18
Homework Problem 18
Module 5-Part 9 Text Functions and Analyzing NFL plays
Excel Files
Recommended Reading
5.9 Text functions and Analyzing NFL plays
()
Module 5-Part 10 Texans 1st and 10 Play Selection
Excel Files
5.10 Texans 1st and 10 Play Selection
()
Module 5-Part 11 STDEVIF and Too Many Field Goal Attempts
Excel Files
5.11 STDEVIF and Too Many Field Goal Attempts
()
Module 5-Homework Problem 19
Homework Problem 19
Module 6-Part 1 Game Theory Part I
Download Excel Files (Important!)
Excel Files
Recommended Reading
6.1 Game Theory Part I
()
Module 6-Part 2 Game Theory Part II
Excel Files
6.2 Game Theory Part II
()
Module 6-Homework Problem 20
Homework Problem 20
Module 6-Part 3 Basketball Shot Selection
Excel Files
6.3 Basketball Shot Selection
()
Module 6-Part 4 Effective Field Goal Percentage (EFG)
Excel Files
Recommended Reading
6.4 Effective Field Goal Percentage (EFG)
()
Module 6-Homework Problem 21
Homework Problem 21
Module 6-Part 5 Hollinger Team Metrics
Excel Files
6.5 Hollinger Team Metrics
()
Module 6-Part 6 Four Factors
Excel Files
Recommended Reading
6.6 Four Factors
()
Module 6-Homework Problem 22
Homework Problem 22
Module 6-Part 7 Basketball Box Score Models
Excel Files
Recommended Reading
6.7 Basketball Box Score Models
()
Module 6-Homework Problem 23
Homework Problem 23
Module 7-Part 1 Extracting Lineup data and Computing raw + -
Download Excel Files (Important!)
Excel Files
7.1 Extracting Lineup data and Computing raw + -
()
Module 7-Part 2 Computing Pairs Lineup Statistics
Excel Files
7.2 Computing Pairs Lineup Statistics
()
Module 7-Part 3 Adjusted + -
Excel Files
7.3 Adjusted + -
()
Module 7-Homework Problem 24
Homework Problem 24
Module 7-Part 4 ESPM RPM (Real Plus Minus)
Excel Files
7.4 ESPM RPM (Real Plus Minus)
()
Module 7-Homework Problem 25
Homework Problem 25
Module 7-Part 5 How Analytics Helped the Mavs beat the Heat
Excel Files
7.5 How Analytics Helped the Mavs beat the Heat
()
Module 7-Part 6 SportsVu data
Excel Files
7.6 SportsVu data
()
Module 7-Homework Problem 26
Homework Problem 26
Module 7-Part 7 In Game Basketball Decision-Making
Excel Files
7.7 In Game Basketball Decision-Making
()
Module 7-Part 8 Hack a Jordan (or Dwight)
Excel Files
7.8 Hack a Jordan (or Dwight)
()
Module 7-Homework Problem 27
Homework Problem 27
Module 8-Part 1 Rating NFL teams
Download Excel Files (Important!)
Excel Files
Recommended Reading
8.1 Rating NFL teams
()
Module 8-Homework Problem 28
Homework Problem 28
Module 8-Part 2 Computing Strength of Schedule
Excel Files
Recommended Reading
8.2 Computing Strength of Schedule
()
Module 8-Homework Problem 29
Homework Problem 29
Module 8-Part 3 Rating NFL Offenses and Defenses
Excel Files
Recommended Reading
8.3 Rating NFL Offenses and Defenses
()
Module 8-Homework Problem 30
Homework Problem 30
Module 8-Part 4 Multiplicative Rating Models for Soccer
Excel Files
Recommended Reading
8.4 Multiplicative Rating Models for Soccer
()
Module 8-Homework Problem 31
Homework Problem 31
Module 8-Part 5 Regularization
Excel Files
8.5 Regularization
()
Module 8-Part 6 Simulating the NCAA Tournament
Excel Files
Recommended Reading
8.6 Simulating the NCAA Tournament
()
Module 8-Part 7 NCAA Props Bets
Excel Files
8.7 NCAA Props Bets
()
Module 8-Homework Problem 32
Homework Problem 32
Module 9-Part 1 Method of Maximum Likelihood
Download Excel Files (Important!)
Excel Files
Recommended Reading
9.1 Method of Maximum Likelihood
()
Module 9-Part 2 Rating Teams Based on Wins and Losses
Excel Files
Recommended Reading
9.2 Rating Teams Based on Wins and Losses
()
Module 9-Homework Problem 33
Homework Problem 33
Module 9-Part 3 Simulating the NFL Playoffs
Excel Files
9.3 Simulating the NFL Playoffs
()
Module 9-Part 4 Rating NASCAR Drivers
Excel Files
9.4 Rating NASCAR Drivers
()
Module 9-Part 5 How Good are NFL Point Spreads?
Excel Files
9.5 How Good are NFL Point Spreads
()
Module 9-Part 6 Relating the Money Line to Point Spreads
Excel Files
9.6 Relating the Money Line to Point Spreads
()
Recommended Reading
Module 9-Homework Problem 34
Homework Problem 34
Module 9-Part 7 How Can you tell if a Betting System is Successful?
Excel Files
9.7 How Can you tell if a Betting System is Successful?
()
Module 9-Homework Problem 35
Homework Problem 35
Module 9-Part 8 Props Bets I
Excel Files
Recommended Reading
9.8 Props Bets I
()
Module 9-Part 9 Props Bets II
Excel Files
9.9 Props Bet II
()
Module 9-Part 10 Props Bets III
Excel Files
9.10 Props Bet III
()
Module 9-Homework Problem 36
Homework Problem 36
Module 10-Part 1 Kelly Growth Part I
Download Excel Files (Important!)
Excel Files
Recommended Reading
10.1 Kelly Growth Part I
()
Module 10- Part 2 Kelly Growth Part II
Excel Files
10.2 Kelly Growth Part II
()
Module 10-Part 3 Kelly Growth Part III
Excel Files
10.3 Kelly Growth Part III
()
Module 10-Homework Problem 37
Homework Problem 37
Module 10-Part 4 Regression to the Mean
Excel Files
Recommended Reading
10.4 Regression to the Mean
()
Module 10-Homework Problem 38
Homework Problem 38
Module 10-Part 5 Daily Fantasy Sports Part I
Excel Files
10.5 Daily Fantasy Sports Part I
()
Module 10-Part 6 Daily Fantasy Sports Part II
Excel Files
10.6 Daily Fantasy Sports Part II
()
Module 10-Homework Problem 39
Homework Problem 39
Module 10-Part 7 Golf Analytics
Excel Files
10.7 Golf Analytics
()
Module 10-Homework Problem 40
Homework Problem 40
Final Exam-Final Exam Questions
Download Excel Files
math_m7-Ch1hKurREeWBDQ73-3lhaw.zip
(542 KB)
math_m8-Ch2vS-rREeWBDQ73-3lhaw.zip
(1.2 MB)
math_m6-Cg_MderREeWY_hJaRfO1AQ.zip
(591 KB)
math_m10-CiQXxurREeWY_hJaRfO1AQ.zip
(2.1 MB)
Data41_42-QZcUSPdcEeW42w5vpJam5Q.zip
(110 KB)
math_m9-CiPw3OrREeWBDQ73-3lhaw.zip
(1.3 MB)
math_m2-CgkVt-rREeWOVQ68c1xy2w.zip
(2.1 MB)
math_m1-Cg7h4-rREeW--hK2gi_BIw.zip
(1.0 MB)
math_m3-Cg5ssurREeW--hK2gi_BIw.zip
(771 KB)
math_m5-MsK8QV57EeaDHAoUuWYZGQ.zip
(3.0 MB)
math_m4-ChFS5OrREeW--hK2gi_BIw.zip
(1.5 MB)