Coursera

  • Arts and HumanitiesChevron Right
  • BusinessChevron Right
  • Computer ScienceChevron Right
  • Data ScienceChevron Right
  • Information TechnologyChevron Right
  • Life SciencesChevron Right
  • Math and LogicChevron Right
  • Personal Development
  • Physical Science and EngineeringChevron Right
  • Social SciencesChevron Right
  • Language LearningChevron Right
  • Degrees and CertificatesChevron Right
  • Explore all of Coursera
Loupe Copy
  • Browse
  • Search
  • For Enterprise
  • Log In
  • Sign Up
  • Explore
  • For Enterprise
  • Sign Up
  • Log In
Coursera

Math behind Moneyball

OverviewSyllabusFAQsCreatorsPricingRatings and Reviews

HomeData ScienceData Analysis

Math behind Moneyball

University of Houston System

About this course: Learn how probability, math, and statistics can be used to help baseball, football and basketball teams improve, player and lineup selection as well as in game strategy.

Created by:  University of Houston System
University of Houston System
  • Professor Wayne Winston

    Taught by:  Professor Wayne Winston, Visiting Professor

    Bauer College of Business
LevelBeginner
Language
English
How To PassPass all graded assignments to complete the course.
User Ratings
4.5 stars
Average User Rating 4.5See what learners said
Syllabus
WEEK 1
Before you start...
1 video, 1 reading
  1. Video: All you will learn
  2. Leyendo: Suggested Textbooks (Not Required)
Module 1
You will learn how to predict a team’s won loss record from the number of runs, points, or goals scored by a team and its opponents. Then we will introduce you to multiple regression and show how multiple regression is used to evaluate baseball hitters. Excel data tables, VLOOKUP, MATCH, and INDEX functions will be discussed.
11 videos, 22 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Video: 1.1 Introduction
  3. Leyendo: Excel Files
  4. Leyendo: Recommended reading
  5. Video: 1.2 Pythagorean Theorem
  6. Leyendo: Excel file
  7. Leyendo: Recommended reading
  8. Video: 1.3 Ten runs = One win
  9. Video: Homework Problems 1 and 2
  10. Leyendo: Excel file
  11. Leyendo: Excel file
  12. Leyendo: Recommended reading
  13. Video: 1.4 Runs created
  14. Leyendo: Excel Files
  15. Leyendo: Recommended reading
  16. Video: 1.5 Runs Created Per Game
  17. Leyendo: Homework Problem 3
  18. Leyendo: Excel Files
  19. Leyendo: Recommended reading
  20. Video: 1.6 Multiple Regression 1
  21. Leyendo: Excel Files
  22. Leyendo: Recommended reading
  23. Video: 1.7 Multiple Regression 2
  24. Leyendo: Excel Files
  25. Leyendo: Recommended reading
  26. Video: 1.8 Linear Weights
  27. Leyendo: Excel Files
  28. Leyendo: Recommended reading
  29. Video: 1.9 On Base Percentage + Slugging Percentage
  30. Leyendo: Excel Files
  31. Leyendo: Recommended reading
  32. Video: 1.10 Barry Bonds Runs per Game
  33. Leyendo: Homework Problems 4
Graded: Test Questions 1 and 2
Graded: Test Question 3
Graded: Test Question 4
WEEK 2
Module 2
You will concentrate on learning important Excel tools including Range Names, Tables, Conditional Formatting, PivotTables, and the family of COUNTIFS, SUMIFS, and AVERAGEIFS functions. You will concentrate on learning important Excel tools including Range Names, Tables, Conditional Formatting, PivotTables, and the family of COUNTIFS, SUMIFS, and AVERAGEIFS functions.
10 videos, 23 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 2.1 Excel Range Names
  5. Leyendo: Excel Files
  6. Leyendo: Recommended Reading
  7. Video: 2.2 Excel Tables
  8. Leyendo: Excel Files
  9. Leyendo: Recommended Reading
  10. Video: 2.3 Conditional Formatting: Top Bottom Rules
  11. Leyendo: Excel Files
  12. Leyendo: Recommended Reading
  13. Video: 2.4 Conditional Formatting: Data Bars
  14. Leyendo: Excel Files
  15. Leyendo: Recommended Reading
  16. Video: 2.5 Conditional Formatting: The Formula Option
  17. Leyendo: Excel Files
  18. Leyendo: Recommended Reading
  19. Video: 2.6 COUNTIF and COUNTIFS functions
  20. Leyendo: Excel Files
  21. Leyendo: Recommended Reading
  22. Video: 2.7 SUMIF and SUMIFS Functions
  23. Leyendo: Excel Files
  24. Leyendo: Recommended Reading
  25. Video: 2.8 AVERAGEIF and AVERAGEIFS Functions
  26. Leyendo: Homework Problem 5
  27. Leyendo: Excel Files
  28. Leyendo: Recommended Reading
  29. Video: 2.9 PivotTables I
  30. Leyendo: Excel Files
  31. Leyendo: Recommended Reading
  32. Video: 2.10 PivotTables II
  33. Leyendo: Homework Problem 6
Graded: Test Question 5
Graded: Test Question 6
WEEK 3
Module 3
You will learn how Monte Carlo simulation works and how it can be used to evaluate a baseball team’s offense and the famous DEFLATEGATE controversy.
6 videos, 10 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 3.1 Monte Carlo Simulation I
  5. Leyendo: Excel Files
  6. Video: 3.2 Monte Carlo Simulation Part II
  7. Leyendo: Excel Files
  8. Video: 3.3 Monte Carlo Simulation Part III
  9. Leyendo: Excel Files
  10. Video: 3.4 Baseball Monte Carlo simulation
  11. Leyendo: Excel Files
  12. Leyendo: Recommended Reading
  13. Video: 3.5 Resampling
  14. Leyendo: Excel Files
  15. Video: 3.6 Deflategate
  16. Leyendo: Homework Problem 8
Graded: Test Question 7
Graded: Test Question 8
WEEK 4
Module 4
You will learn how to evaluate baseball fielding, baseball pitchers, and evaluate in game baseball decision-making. The math behind WAR (Wins above Replacement) and Park Factors will also be discussed. Modern developments such as infield shifts and pitch framing will also be discussed.
13 videos, 27 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 4.1 Bunting and Expected Runs
  5. Leyendo: Excel Files
  6. Leyendo: Recommended reading
  7. Video: 4.2 Base Stealing
  8. Leyendo: Homework Problem 9
  9. Leyendo: Excel Files
  10. Leyendo: Recommended Reading
  11. Video: 4.3 Range Factor
  12. Leyendo: Excel Files
  13. Video: 4.4 UZR (Ultimate Zone Rating) and Fielding
  14. Leyendo: Homework Problem 10
  15. Leyendo: Homework Problem 11
  16. Video: 4.5 Introduction to Fan Graphs
  17. Leyendo: Excel Files
  18. Leyendo: Recommended Reading
  19. Video: 4.6 DIPS (Defense Independent Pitching Statistics)
  20. Leyendo: Homework Problem 12
  21. Leyendo: Excel Files
  22. Leyendo: Recommended Reading
  23. Video: 4.7 Win Probability Added
  24. Leyendo: Excel Files
  25. Leyendo: Recommended Reading
  26. Video: 4.8 Runs above Average
  27. Leyendo: Excel Files
  28. Leyendo: Recommended Reading
  29. Video: 4.9 WAR (Wins above Replacement)
  30. Leyendo: Homework Problem 13
  31. Leyendo: Excel Files
  32. Video: 4.10 What Makes your Team Win?
  33. Leyendo: Excel Files
  34. Video: 4.11 Defensive Shifts
  35. Leyendo: Excel Files
  36. Video: 4.12 Catcher Framing
  37. Leyendo: Excel Files
  38. Leyendo: Recommended Reading
  39. Video: 4.13 Park Factors
  40. Leyendo: Homework Problem 14
Graded: Test Question 9
Graded: Test Questions 10&11
Graded: Test Question 12
Graded: Test Question 13
Graded: Test Question 14
WEEK 5
Module 5
You will learn basic concepts involving random variables (specifically the normal random variable, expected value, variance and standard deviation.) You will learn how regression can be used to analyze what makes NFL teams win and decode the NFL QB rating system. You will also learn that momentum and the “hot hand” is mostly a myth. Finally, you will use Excel text functions and the concept of Expected Points per play to analyze the effectiveness of a football team’s play calling.
11 videos, 23 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 5.1 Random Variables
  5. Leyendo: Excel Files
  6. Leyendo: Recommended Reading
  7. Video: 5.2 The Normal Random Variable
  8. Leyendo: Excel Files
  9. Leyendo: Recommended Reading
  10. Video: 5.3 Streakiness
  11. Leyendo: Excel Files
  12. Video: 5.4 What makes NFL teams win?
  13. Leyendo: Homework Problem 15
  14. Leyendo: Excel Files
  15. Video: 5.5 Deconstructing the NFL QB rating
  16. Leyendo: Homework Problem 16
  17. Leyendo: Excel Files
  18. Leyendo: Recommended Reading
  19. Video: 5.6 Football States and Values
  20. Leyendo: Excel Files
  21. Leyendo: Recommended Reading
  22. Video: 5.7 Football Decision Making
  23. Leyendo: Homework Problem 17
  24. Leyendo: Excel Files
  25. Video: 5.8 The Belichick Decision
  26. Leyendo: Homework Problem 18
  27. Leyendo: Excel Files
  28. Leyendo: Recommended Reading
  29. Video: 5.9 Text functions and Analyzing NFL plays
  30. Leyendo: Excel Files
  31. Video: 5.10 Texans 1st and 10 Play Selection
  32. Leyendo: Excel Files
  33. Video: 5.11 STDEVIF and Too Many Field Goal Attempts
  34. Leyendo: Homework Problem 19
Graded: Test Question 15
Graded: Test Question 16
Graded: Test Question 17
Graded: Test Question 18
Graded: Test Question 19
WEEK 6
Module 6
You will learn how two-person zero sum game theory sheds light on football play selection and soccer penalty kick strategies. Our discussion of basketball begins with an analysis of NBA shooting, box score based player metrics, and the Four Factor concept which explains what makes basketball teams win.
7 videos, 16 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 6.1 Game Theory Part I
  5. Leyendo: Excel Files
  6. Video: 6.2 Game Theory Part II
  7. Leyendo: Homework Problem 20
  8. Leyendo: Excel Files
  9. Video: 6.3 Basketball Shot Selection
  10. Leyendo: Excel Files
  11. Leyendo: Recommended Reading
  12. Video: 6.4 Effective Field Goal Percentage (EFG)
  13. Leyendo: Homework Problem 21
  14. Leyendo: Excel Files
  15. Video: 6.5 Hollinger Team Metrics
  16. Leyendo: Excel Files
  17. Leyendo: Recommended Reading
  18. Video: 6.6 Four Factors
  19. Leyendo: Homework Problem 22
  20. Leyendo: Excel Files
  21. Leyendo: Recommended Reading
  22. Video: 6.7 Basketball Box Score Models
  23. Leyendo: Homework Problem 23
Graded: Test Question 20
Graded: Test Question 21
Graded: Test Question 22
Graded: Test Question 23
WEEK 7
Module 7
You will learn about advanced basketball concepts such as Adjusted plus minus, ESPN’s RPM, SportVu data, and NBA in game decision-making.
8 videos, 13 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Video: 7.1 Extracting Lineup data and Computing raw + -
  4. Leyendo: Excel Files
  5. Video: 7.2 Computing Pairs Lineup Statistics
  6. Leyendo: Excel Files
  7. Video: 7.3 Adjusted + -
  8. Leyendo: Homework Problem 24
  9. Leyendo: Excel Files
  10. Video: 7.4 ESPM RPM (Real Plus Minus)
  11. Leyendo: Homework Problem 25
  12. Leyendo: Excel Files
  13. Video: 7.5 How Analytics Helped the Mavs beat the Heat
  14. Leyendo: Excel Files
  15. Video: 7.6 SportsVu data
  16. Leyendo: Homework Problem 26
  17. Leyendo: Excel Files
  18. Video: 7.7 In Game Basketball Decision-Making
  19. Leyendo: Excel Files
  20. Video: 7.8 Hack a Jordan (or Dwight)
  21. Leyendo: Homework Problem 27
Graded: Test 24
Graded: Test 25
Graded: Test 26
Graded: Test 27
WEEK 8
Module 8
You will learn how to use game results to rate sports teams and set point spreads. Simulation of the NCAA basketball tournament will aid you in filling out your 2016 bracket. Final 4 is in Houston!
7 videos, 18 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 8.1 Rating NFL teams
  5. Leyendo: Homework Problem 28
  6. Leyendo: Excel Files
  7. Leyendo: Recommended Reading
  8. Video: 8.2 Computing Strength of Schedule
  9. Leyendo: Homework Problem 29
  10. Leyendo: Excel Files
  11. Leyendo: Recommended Reading
  12. Video: 8.3 Rating NFL Offenses and Defenses
  13. Leyendo: Homework Problem 30
  14. Leyendo: Excel Files
  15. Leyendo: Recommended Reading
  16. Video: 8.4 Multiplicative Rating Models for Soccer
  17. Leyendo: Homework Problem 31
  18. Leyendo: Excel Files
  19. Video: 8.5 Regularization
  20. Leyendo: Excel Files
  21. Leyendo: Recommended Reading
  22. Video: 8.6 Simulating the NCAA Tournament
  23. Leyendo: Excel Files
  24. Video: 8.7 NCAA Props Bets
  25. Leyendo: Homework Problem 32
Graded: Test 28
Graded: Test 29
Graded: Test 30
Graded: Test 31
Graded: Test 32
WEEK 9
Module 9
You will learn how to rate NASCAR drivers and get an introduction to sports betting concepts such as the Money line, Props Bets, and evaluation of gambling betting systems.
10 videos, 19 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 9.1 Method of Maximum Likelihood
  5. Leyendo: Excel Files
  6. Leyendo: Recommended Reading
  7. Video: 9.2 Rating Teams Based on Wins and Losses
  8. Leyendo: Homework Problem 33
  9. Leyendo: Excel Files
  10. Video: 9.3 Simulating the NFL Playoffs
  11. Leyendo: Excel Files
  12. Video: 9.4 Rating NASCAR Drivers
  13. Leyendo: Excel Files
  14. Video: 9.5 How Good are NFL Point Spreads
  15. Leyendo: Excel Files
  16. Video: 9.6 Relating the Money Line to Point Spreads
  17. Leyendo: Recommended Reading
  18. Leyendo: Homework Problem 34
  19. Leyendo: Excel Files
  20. Video: 9.7 How Can you tell if a Betting System is Successful?
  21. Leyendo: Homework Problem 35
  22. Leyendo: Excel Files
  23. Leyendo: Recommended Reading
  24. Video: 9.8 Props Bets I
  25. Leyendo: Excel Files
  26. Video: 9.9 Props Bet II
  27. Leyendo: Excel Files
  28. Video: 9.10 Props Bet III
  29. Leyendo: Homework Problem 36
Graded: Test 33
Graded: Test 34
Graded: Test 35
Graded: Test 36
WEEK 10
Module 10
You will learn how Kelly Growth can optimize your sports betting, how regression to the mean explains the SI cover jinx and how to optimize a daily fantasy sports lineup. We close with a discussion of golf analytics.
7 videos, 14 readings
  1. Leyendo: Download Excel Files (Important!)
  2. Leyendo: Excel Files
  3. Leyendo: Recommended Reading
  4. Video: 10.1 Kelly Growth Part I
  5. Leyendo: Excel Files
  6. Video: 10.2 Kelly Growth Part II
  7. Leyendo: Excel Files
  8. Video: 10.3 Kelly Growth Part III
  9. Leyendo: Homework Problem 37
  10. Leyendo: Excel Files
  11. Leyendo: Recommended Reading
  12. Video: 10.4 Regression to the Mean
  13. Leyendo: Homework Problem 38
  14. Leyendo: Excel Files
  15. Video: 10.5 Daily Fantasy Sports Part I
  16. Leyendo: Excel Files
  17. Video: 10.6 Daily Fantasy Sports Part II
  18. Leyendo: Homework Problem 39
  19. Leyendo: Excel Files
  20. Video: 10.7 Golf Analytics
  21. Leyendo: Homework Problem 40
Graded: Test 37
Graded: Test 38
Graded: Test 39
Graded: Test 40
WEEK 11
Final Exam
Final exam has 10 questions. Please download and open Excel files before taking the exam. You will be referred to Excel files during the exam. Each question is wort 1 point. You need to answer 6 questions or more correctly to pass the exam.
1 reading
  1. Leyendo: Download Excel Files
Graded: Final Exam

FAQs
How It Works
Trabajo del curso
Trabajo del curso

Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.

Ayuda de tus compañeros
Ayuda de tus compañeros

Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.

Certificados
Certificados

Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.

Creators
University of Houston System
The University of Houston System’s four universities and six regional campuses comprise the only comprehensive higher education system serving the world’s energy capital and the Gulf Coast region. Among institutions nationwide, the UH System remains a model of diversity and a reflection of the city it serves.
Pricing
Purchase Course
Access to course materials

Available

Access to graded materials

Available

Receive a final grade

Available

Earn a shareable Course Certificate

Available

Ratings and Reviews
Rated 4.5 out of 5 of 37 ratings
Javier Ochoa

Excellent course if you like statistics, probabilities, and how to linh sport with math. Well explained. Maybe it needs more "movement" on forums

Michael Sweet

This is one of the very the best classes I've ever taken. It provided the tools in Excel and the methods to model various sports outcomes so that I can start creating my own models. The examples were wide ranging and interesting. I thoroughly enjoyed listening to Professor Winston and appreciated all the additional references he pointed out during the lectures. I would love to see a second course in sports analytics . I do wish this course was called "Introduction to Sports Analytics", or "Sports Analytics I" so it would be easier to find. It seems like this course should have many more reviews than it does. Also, some of the course data may need updated. Highly recommended to anyone interested in sportsbetting or fantasy sports.

SP

Great course, however very heavy emphasis on Baseball and NFL. Resultantly some of the assessment questions proved impossible given the knowledge needed about the sport.

B

Wow, this is quite the crash course in sports analytics and Excel tricks! I was familiar with most of the concepts, but enjoyed seeing how easily all of these advanced stats could be calculated, and learned some really useful Excel functionality (what-if analysis, solver). The amount of material that is covered is really impressive!

Biggest problem with this course: it doesn't turn up when you search for "sports analytics" in Coursera's search - luckily for me mooclist.com knows about it



You May Also Like
University of Colorado Boulder
Effective Communication Capstone Project
1 course
University of Colorado Boulder
Effective Communication Capstone Project
View course
Yonsei University
Emerging Technologies Capstone
1 course
Yonsei University
Emerging Technologies Capstone
View course
University of California San Diego, National Research University Higher School of Economics
Delivery Problem
1 course
University of California San Diego, National Research University Higher School of Economics
Delivery Problem
View course
University of California San Diego, National Research University Higher School of Economics
Combinatorics and Probability
1 course
University of California San Diego, National Research University Higher School of Economics
Combinatorics and Probability
View course
University of California San Diego, National Research University Higher School of Economics
Introduction to Graph Theory
1 course
University of California San Diego, National Research University Higher School of Economics
Introduction to Graph Theory
View course
Coursera
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
© 2018 Coursera Inc. All rights reserved.
Download on the App StoreGet it on Google Play
  • Coursera
  • About
  • Leadership
  • Careers
  • Catalog
  • Certificates
  • Degrees
  • For Business
  • For Government
  • Community
  • Partners
  • Mentors
  • Translators
  • Developers
  • Beta Testers
  • Connect
  • Blog
  • Facebook
  • LinkedIn
  • Twitter
  • Google+
  • Tech Blog
  • More
  • Terms
  • Privacy
  • Help
  • Accessibility
  • Press
  • Contact
  • Directory
  • Affiliates