Acerca de este Curso
9,135 vistas recientes

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel principiante

Aprox. 16 horas para completar

Inglés (English)

Subtítulos: Inglés (English)

Habilidades que obtendrás

StatisticsAnalyticsMicrosoft ExcelProbability

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel principiante

Aprox. 16 horas para completar

Inglés (English)

Subtítulos: Inglés (English)

Programa - Qué aprenderás en este curso

Semana
1
3 minutos para completar

Before you start...

...
1 video (Total 2 minutos), 1 reading
1 video
1 lectura
Suggested Textbooks (Not Required)1m
5 horas para completar

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 (Total 90 minutos), 22 readings, 3 quizzes
11 videos
1.2 Pythagorean Theorem12m
1.3 Ten runs = One win6m
Homework Problems 1 and 23m
1.4 Runs created7m
1.5 Runs Created Per Game5m
1.6 Multiple Regression 117m
1.7 Multiple Regression 26m
1.8 Linear Weights6m
1.9 On Base Percentage + Slugging Percentage4m
1.10 Barry Bonds Runs per Game6m
22 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended reading10m
Excel file10m
Recommended reading10m
Excel file10m
Excel file10m
Recommended reading10m
Excel Files10m
Recommended reading10m
Homework Problem 310m
Excel Files10m
Recommended reading10m
Excel Files10m
Recommended reading10m
Excel Files10m
Recommended reading10m
Excel Files10m
Recommended reading10m
Excel Files10m
Recommended reading10m
Homework Problems 410m
3 ejercicios de práctica
Test Questions 1 and 24m
Test Question 32m
Test Question 42m
Semana
2
5 horas para completar

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 (Total 76 minutos), 23 readings, 2 quizzes
10 videos
2.2 Excel Tables5m
2.3 Conditional Formatting: Top Bottom Rules7m
2.4 Conditional Formatting: Data Bars7m
2.5 Conditional Formatting: The Formula Option11m
2.6 COUNTIF and COUNTIFS functions9m
2.7 SUMIF and SUMIFS Functions5m
2.8 AVERAGEIF and AVERAGEIFS Functions6m
2.9 PivotTables I9m
2.10 PivotTables II8m
23 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Homework Problem 510m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Homework Problem 610m
2 ejercicios de práctica
Test Question 52m
Test Question 62m
Semana
3
3 horas para completar

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 (Total 71 minutos), 10 readings, 2 quizzes
6 videos
3.2 Monte Carlo Simulation Part II10m
3.3 Monte Carlo Simulation Part III8m
3.4 Baseball Monte Carlo simulation15m
3.5 Resampling11m
3.6 Deflategate8m
10 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 810m
2 ejercicios de práctica
Test Question 72m
Test Question 82m
Semana
4
6 horas para completar

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 (Total 88 minutos), 27 readings, 5 quizzes
13 videos
4.2 Base Stealing6m
4.3 Range Factor7m
4.4 UZR (Ultimate Zone Rating) and Fielding12m
4.5 Introduction to Fan Graphs3m
4.6 DIPS (Defense Independent Pitching Statistics)8m
4.7 Win Probability Added7m
4.8 Runs above Average6m
4.9 WAR (Wins above Replacement)7m
4.10 What Makes your Team Win?2m
4.11 Defensive Shifts8m
4.12 Catcher Framing6m
4.13 Park Factors6m
27 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended reading10m
Homework Problem 910m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 1010m
Homework Problem 1110m
Excel Files10m
Recommended Reading10m
Homework Problem 1210m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Homework Problem 1310m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Recommended Reading10m
Homework Problem 1410m
5 ejercicios de práctica
Test Question 92m
Test Questions 10&114m
Test Question 122m
Test Question 132m
Test Question 142m
Semana
5
6 horas para completar

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 (Total 117 minutos), 23 readings, 5 quizzes
11 videos
5.2 The Normal Random Variable20m
5.3 Streakiness10m
5.4 What makes NFL teams win?13m
5.5 Deconstructing the NFL QB rating6m
5.6 Football States and Values10m
5.7 Football Decision Making9m
5.8 The Belichick Decision9m
5.9 Text functions and Analyzing NFL plays13m
5.10 Texans 1st and 10 Play Selection8m
5.11 STDEVIF and Too Many Field Goal Attempts7m
23 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 1510m
Excel Files10m
Homework Problem 1610m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Homework Problem 1710m
Excel Files10m
Homework Problem 1810m
Excel Files10m
Recommended Reading10m
Excel Files10m
Excel Files10m
Homework Problem 1910m
5 ejercicios de práctica
Test Question 152m
Test Question 162m
Test Question 172m
Test Question 182m
Test Question 192m
Semana
6
4 horas para completar

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 (Total 69 minutos), 16 readings, 4 quizzes
7 videos
6.2 Game Theory Part II8m
6.3 Basketball Shot Selection12m
6.4 Effective Field Goal Percentage (EFG)3m
6.5 Hollinger Team Metrics5m
6.6 Four Factors10m
6.7 Basketball Box Score Models13m
16 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 2010m
Excel Files10m
Excel Files10m
Recommended Reading10m
Homework Problem 2110m
Excel Files10m
Excel Files10m
Recommended Reading10m
Homework Problem 2210m
Excel Files10m
Recommended Reading10m
Homework Problem 2310m
4 ejercicios de práctica
Test Question 202m
Test Question 212m
Test Question 222m
Test Question 232m
Semana
7
4 horas para completar

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 (Total 98 minutos), 13 readings, 4 quizzes
8 videos
7.2 Computing Pairs Lineup Statistics9m
7.3 Adjusted + -15m
7.4 ESPM RPM (Real Plus Minus)13m
7.5 How Analytics Helped the Mavs beat the Heat12m
7.6 SportsVu data13m
7.7 In Game Basketball Decision-Making12m
7.8 Hack a Jordan (or Dwight)4m
13 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problem 2410m
Excel Files10m
Homework Problem 2510m
Excel Files10m
Excel Files10m
Homework Problem 2610m
Excel Files10m
Excel Files10m
Homework Problem 2710m
4 ejercicios de práctica
Test 242m
Test 254m
Test 262m
Test 272m
Semana
8
5 horas para completar

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 (Total 88 minutos), 18 readings, 5 quizzes
7 videos
8.2 Computing Strength of Schedule11m
8.3 Rating NFL Offenses and Defenses11m
8.4 Multiplicative Rating Models for Soccer17m
8.5 Regularization7m
8.6 Simulating the NCAA Tournament12m
8.7 NCAA Props Bets8m
18 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Homework Problem 2810m
Excel Files10m
Recommended Reading10m
Homework Problem 2910m
Excel Files10m
Recommended Reading10m
Homework Problem 3010m
Excel Files10m
Recommended Reading10m
Homework Problem 3110m
Excel Files10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 3210m
5 ejercicios de práctica
Test 282m
Test 292m
Test 302m
Test 312m
Test 322m
Semana
9
5 horas para completar

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 (Total 97 minutos), 19 readings, 4 quizzes
10 videos
9.2 Rating Teams Based on Wins and Losses9m
9.3 Simulating the NFL Playoffs4m
9.4 Rating NASCAR Drivers10m
9.5 How Good are NFL Point Spreads15m
9.6 Relating the Money Line to Point Spreads9m
9.7 How Can you tell if a Betting System is Successful?11m
9.8 Props Bets I11m
9.9 Props Bet II10m
9.10 Props Bet III5m
19 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Recommended Reading10m
Homework Problem 3310m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Recommended Reading10m
Homework Problem 3410m
Excel Files10m
Homework Problem 3510m
Excel Files10m
Recommended Reading10m
Excel Files10m
Excel Files10m
Homework Problem 3610m
4 ejercicios de práctica
Test 332m
Test 342m
Test 352m
Test 362m
Semana
10
4 horas para completar

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 (Total 73 minutos), 14 readings, 4 quizzes
7 videos
10.2 Kelly Growth Part II5m
10.3 Kelly Growth Part III6m
10.4 Regression to the Mean14m
10.5 Daily Fantasy Sports Part I8m
10.6 Daily Fantasy Sports Part II18m
10.7 Golf Analytics10m
14 lecturas
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Excel Files10m
Homework Problem 3710m
Excel Files10m
Recommended Reading10m
Homework Problem 3810m
Excel Files10m
Excel Files10m
Homework Problem 3910m
Excel Files10m
Homework Problem 4010m
4 ejercicios de práctica
Test 372m
Test 382m
Test 392m
Test 402m
Semana
11
1 hora para completar

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 quiz
1 lectura
Download Excel Files10m
1 ejercicio de práctica
Final Exam20m
4.5
9 revisionesChevron Right

Principales revisiones sobre Math behind Moneyball

por HHFeb 6th 2017

Pretty good course where you learn how to analyse performance via various statistical analysis techniques. You also learn quite a bit in MS Excel.

Instructor

Avatar

Professor Wayne Winston

Visiting Professor
Bauer College of Business

Acerca de Sistema Universitario de Houston

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....

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • Cuando compras un Certificado, obtienes acceso a todos los materiales del curso, incluidas las tareas calificadas. Una vez que completes el curso, se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes participar del curso como oyente sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.