Acerca de este curso: 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.
Creada por: University of Houston System
Enseñado por: Professor Wayne Winston, Visiting Professor
Bauer College of Business
| Nivel | Principiante |
| Idioma | English |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
Programa
SEMANA 1
Before you start...
1 videos, 1 lecturas
- 阅读: 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.2 Pythagorean Theorem
- 阅读: Excel file
- 阅读: Recommended reading
- Vídeo: 1.3 Ten runs = One win
- Vídeo: Homework Problems 1 and 2
- 阅读: Excel file
- 阅读: Excel file
- 阅读: Recommended reading
- Vídeo: 1.4 Runs created
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.5 Runs Created Per Game
- 阅读: Homework Problem 3
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.6 Multiple Regression 1
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.7 Multiple Regression 2
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.8 Linear Weights
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.9 On Base Percentage + Slugging Percentage
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 1.10 Barry Bonds Runs per Game
- 阅读: Homework Problems 4
Calificado: Test Questions 1 and 2
Calificado: Test Question 3
Calificado: Test Question 4
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.2 Excel Tables
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.3 Conditional Formatting: Top Bottom Rules
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.4 Conditional Formatting: Data Bars
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.5 Conditional Formatting: The Formula Option
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.6 COUNTIF and COUNTIFS functions
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.7 SUMIF and SUMIFS Functions
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.8 AVERAGEIF and AVERAGEIFS Functions
- 阅读: Homework Problem 5
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.9 PivotTables I
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 2.10 PivotTables II
- 阅读: Homework Problem 6
Calificado: Test Question 5
Calificado: Test Question 6
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- Vídeo: 3.2 Monte Carlo Simulation Part II
- 阅读: Excel Files
- Vídeo: 3.3 Monte Carlo Simulation Part III
- 阅读: Excel Files
- Vídeo: 3.4 Baseball Monte Carlo simulation
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 3.5 Resampling
- 阅读: Excel Files
- Vídeo: 3.6 Deflategate
- 阅读: Homework Problem 8
Calificado: Test Question 7
Calificado: Test Question 8
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- 阅读: Recommended reading
- Vídeo: 4.2 Base Stealing
- 阅读: Homework Problem 9
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.3 Range Factor
- 阅读: Excel Files
- Vídeo: 4.4 UZR (Ultimate Zone Rating) and Fielding
- 阅读: Homework Problem 10
- 阅读: Homework Problem 11
- Vídeo: 4.5 Introduction to Fan Graphs
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.6 DIPS (Defense Independent Pitching Statistics)
- 阅读: Homework Problem 12
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.7 Win Probability Added
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.8 Runs above Average
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.9 WAR (Wins above Replacement)
- 阅读: Homework Problem 13
- 阅读: Excel Files
- Vídeo: 4.10 What Makes your Team Win?
- 阅读: Excel Files
- Vídeo: 4.11 Defensive Shifts
- 阅读: Excel Files
- Vídeo: 4.12 Catcher Framing
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 4.13 Park Factors
- 阅读: Homework Problem 14
Calificado: Test Question 9
Calificado: Test Questions 10&11
Calificado: Test Question 12
Calificado: Test Question 13
Calificado: Test Question 14
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 5.2 The Normal Random Variable
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 5.3 Streakiness
- 阅读: Excel Files
- Vídeo: 5.4 What makes NFL teams win?
- 阅读: Homework Problem 15
- 阅读: Excel Files
- Vídeo: 5.5 Deconstructing the NFL QB rating
- 阅读: Homework Problem 16
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 5.6 Football States and Values
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 5.7 Football Decision Making
- 阅读: Homework Problem 17
- 阅读: Excel Files
- Vídeo: 5.8 The Belichick Decision
- 阅读: Homework Problem 18
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 5.9 Text functions and Analyzing NFL plays
- 阅读: Excel Files
- Vídeo: 5.10 Texans 1st and 10 Play Selection
- 阅读: Excel Files
- Vídeo: 5.11 STDEVIF and Too Many Field Goal Attempts
- 阅读: Homework Problem 19
Calificado: Test Question 15
Calificado: Test Question 16
Calificado: Test Question 17
Calificado: Test Question 18
Calificado: Test Question 19
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- Vídeo: 6.2 Game Theory Part II
- 阅读: Homework Problem 20
- 阅读: Excel Files
- Vídeo: 6.3 Basketball Shot Selection
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 6.4 Effective Field Goal Percentage (EFG)
- 阅读: Homework Problem 21
- 阅读: Excel Files
- Vídeo: 6.5 Hollinger Team Metrics
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 6.6 Four Factors
- 阅读: Homework Problem 22
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 6.7 Basketball Box Score Models
- 阅读: Homework Problem 23
Calificado: Test Question 20
Calificado: Test Question 21
Calificado: Test Question 22
Calificado: Test Question 23
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Excel Files
- Vídeo: 7.2 Computing Pairs Lineup Statistics
- 阅读: Excel Files
- Vídeo: 7.3 Adjusted + -
- 阅读: Homework Problem 24
- 阅读: Excel Files
- Vídeo: 7.4 ESPM RPM (Real Plus Minus)
- 阅读: Homework Problem 25
- 阅读: Excel Files
- Vídeo: 7.5 How Analytics Helped the Mavs beat the Heat
- 阅读: Excel Files
- Vídeo: 7.6 SportsVu data
- 阅读: Homework Problem 26
- 阅读: Excel Files
- Vídeo: 7.7 In Game Basketball Decision-Making
- 阅读: Excel Files
- Vídeo: 7.8 Hack a Jordan (or Dwight)
- 阅读: Homework Problem 27
Calificado: Test 24
Calificado: Test 25
Calificado: Test 26
Calificado: Test 27
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Homework Problem 28
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 8.2 Computing Strength of Schedule
- 阅读: Homework Problem 29
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 8.3 Rating NFL Offenses and Defenses
- 阅读: Homework Problem 30
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 8.4 Multiplicative Rating Models for Soccer
- 阅读: Homework Problem 31
- 阅读: Excel Files
- Vídeo: 8.5 Regularization
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 8.6 Simulating the NCAA Tournament
- 阅读: Excel Files
- Vídeo: 8.7 NCAA Props Bets
- 阅读: Homework Problem 32
Calificado: Test 28
Calificado: Test 29
Calificado: Test 30
Calificado: Test 31
Calificado: Test 32
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 9.2 Rating Teams Based on Wins and Losses
- 阅读: Homework Problem 33
- 阅读: Excel Files
- Vídeo: 9.3 Simulating the NFL Playoffs
- 阅读: Excel Files
- Vídeo: 9.4 Rating NASCAR Drivers
- 阅读: Excel Files
- Vídeo: 9.5 How Good are NFL Point Spreads
- 阅读: Excel Files
- Vídeo: 9.6 Relating the Money Line to Point Spreads
- 阅读: Recommended Reading
- 阅读: Homework Problem 34
- 阅读: Excel Files
- Vídeo: 9.7 How Can you tell if a Betting System is Successful?
- 阅读: Homework Problem 35
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 9.8 Props Bets I
- 阅读: Excel Files
- Vídeo: 9.9 Props Bet II
- 阅读: Excel Files
- Vídeo: 9.10 Props Bet III
- 阅读: Homework Problem 36
Calificado: Test 33
Calificado: Test 34
Calificado: Test 35
Calificado: Test 36
SEMANA 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 lecturas
- 阅读: Download Excel Files (Important!)
- 阅读: Excel Files
- 阅读: Recommended Reading
- 阅读: Excel Files
- Vídeo: 10.2 Kelly Growth Part II
- 阅读: Excel Files
- Vídeo: 10.3 Kelly Growth Part III
- 阅读: Homework Problem 37
- 阅读: Excel Files
- 阅读: Recommended Reading
- Vídeo: 10.4 Regression to the Mean
- 阅读: Homework Problem 38
- 阅读: Excel Files
- Vídeo: 10.5 Daily Fantasy Sports Part I
- 阅读: Excel Files
- Vídeo: 10.6 Daily Fantasy Sports Part II
- 阅读: Homework Problem 39
- 阅读: Excel Files
- Vídeo: 10.7 Golf Analytics
- 阅读: Homework Problem 40
Calificado: Test 37
Calificado: Test 38
Calificado: Test 39
Calificado: Test 40
SEMANA 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 lecturas
- 阅读: Download Excel Files
Calificado: Final Exam
Preguntas Frecuentes
Cómo funciona
课程作业
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
来自同学的帮助
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
证书
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
Creadores
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.
Tarifa
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
Calificaciones y revisiones
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.
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.
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
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
Excellent course if you like statistics, probabilities, and how to linh sport with math. Well explained. Maybe it needs more "movement" on forums