Informações sobre o curso

10,495 visualizações recentes

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.

Learner Career Outcomes

33%

comecei uma nova carreira após concluir estes cursos

25%

consegui um benefício significativo de carreira com este curso

100% on-line

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 17 horas para completar

Inglês

Legendas: Inglês

Habilidades que você terá

StatisticsAnalyticsMicrosoft ExcelProbability

Learner Career Outcomes

33%

comecei uma nova carreira após concluir estes cursos

25%

consegui um benefício significativo de carreira com este curso

100% on-line

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 17 horas para completar

Inglês

Legendas: Inglês

Programa - O que você aprenderá com este curso

Semana

1

3 minutos para concluir

Before you start...

1 vídeo (Total 2 mín.), 1 leitura

1 vídeos

All you will learn2min

1 leituras

Suggested Textbooks (Not Required)1min

5 horas para concluir

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 vídeos (Total 90 mín.), 22 leituras, 3 testes

11 videos

1.1 Introduction12min

1.2 Pythagorean Theorem12min

1.3 Ten runs = One win6min

Homework Problems 1 and 23min

1.4 Runs created7min

1.5 Runs Created Per Game5min

1.6 Multiple Regression 117min

1.7 Multiple Regression 26min

1.8 Linear Weights6min

1.9 On Base Percentage + Slugging Percentage4min

1.10 Barry Bonds Runs per Game6min

22 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended reading10min

Excel file10min

Recommended reading10min

Excel file10min

Recommended reading10min

Excel Files10min

Recommended reading10min

Homework Problem 310min

Excel Files10min

Recommended reading10min

Excel Files10min

Recommended reading10min

Excel Files10min

Recommended reading10min

Excel Files10min

Recommended reading10min

Excel Files10min

Recommended reading10min

Homework Problems 410min

3 exercícios práticos

Test Questions 1 and 24min

Test Question 32min

Test Question 42min

Semana

2

5 horas para concluir

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 vídeos (Total 76 mín.), 23 leituras, 2 testes

10 videos

2.1 Excel Range Names5min

2.2 Excel Tables5min

2.3 Conditional Formatting: Top Bottom Rules7min

2.4 Conditional Formatting: Data Bars7min

2.5 Conditional Formatting: The Formula Option11min

2.6 COUNTIF and COUNTIFS functions9min

2.7 SUMIF and SUMIFS Functions5min

2.8 AVERAGEIF and AVERAGEIFS Functions6min

2.9 PivotTables I9min

2.10 PivotTables II8min

23 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Homework Problem 510min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Homework Problem 610min

2 exercícios práticos

Test Question 52min

Test Question 62min

Semana

3

3 horas para concluir

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 vídeos (Total 71 mín.), 10 leituras, 2 testes

6 videos

3.1 Monte Carlo Simulation I15min

3.2 Monte Carlo Simulation Part II10min

3.3 Monte Carlo Simulation Part III8min

3.4 Baseball Monte Carlo simulation15min

3.5 Resampling11min

3.6 Deflategate8min

10 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 810min

2 exercícios práticos

Test Question 72min

Test Question 82min

Semana

4

6 horas para concluir

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 vídeos (Total 88 mín.), 27 leituras, 5 testes

13 videos

4.1 Bunting and Expected Runs5min

4.2 Base Stealing6min

4.3 Range Factor7min

4.4 UZR (Ultimate Zone Rating) and Fielding12min

4.5 Introduction to Fan Graphs3min

4.6 DIPS (Defense Independent Pitching Statistics)8min

4.7 Win Probability Added7min

4.8 Runs above Average6min

4.9 WAR (Wins above Replacement)7min

4.10 What Makes your Team Win?2min

4.11 Defensive Shifts8min

4.12 Catcher Framing6min

4.13 Park Factors6min

27 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended reading10min

Homework Problem 910min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 1010min

Homework Problem 1110min

Excel Files10min

Recommended Reading10min

Homework Problem 1210min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Homework Problem 1310min

Excel Files10min

Recommended Reading10min

Homework Problem 1410min

5 exercícios práticos

Test Question 92min

Test Questions 10&114min

Test Question 122min

Test Question 132min

Test Question 142min

Semana

5

6 horas para concluir

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 vídeos (Total 117 mín.), 23 leituras, 5 testes

11 videos

5.1 Random Variables7min

5.2 The Normal Random Variable20min

5.3 Streakiness10min

5.4 What makes NFL teams win?13min

5.5 Deconstructing the NFL QB rating6min

5.6 Football States and Values10min

5.7 Football Decision Making9min

5.8 The Belichick Decision9min

5.9 Text functions and Analyzing NFL plays13min

5.10 Texans 1st and 10 Play Selection8min

5.11 STDEVIF and Too Many Field Goal Attempts7min

23 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 1510min

Excel Files10min

Homework Problem 1610min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Homework Problem 1710min

Excel Files10min

Homework Problem 1810min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 1910min

5 exercícios práticos

Test Question 152min

Test Question 162min

Test Question 172min

Test Question 182min

Test Question 192min

Semana

6

4 horas para concluir

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 vídeos (Total 69 mín.), 16 leituras, 4 testes

7 videos

6.1 Game Theory Part I12min

6.2 Game Theory Part II8min

6.3 Basketball Shot Selection12min

6.4 Effective Field Goal Percentage (EFG)3min

6.5 Hollinger Team Metrics5min

6.6 Four Factors10min

6.7 Basketball Box Score Models13min

16 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 2010min

Excel Files10min

Recommended Reading10min

Homework Problem 2110min

Excel Files10min

Recommended Reading10min

Homework Problem 2210min

Excel Files10min

Recommended Reading10min

Homework Problem 2310min

4 exercícios práticos

Test Question 202min

Test Question 212min

Test Question 222min

Test Question 232min

Semana

7

4 horas para concluir

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 vídeos (Total 98 mín.), 13 leituras, 4 testes

8 videos

7.1 Extracting Lineup data and Computing raw + -16min

7.2 Computing Pairs Lineup Statistics9min

7.3 Adjusted + -15min

7.4 ESPM RPM (Real Plus Minus)13min

7.5 How Analytics Helped the Mavs beat the Heat12min

7.6 SportsVu data13min

7.7 In Game Basketball Decision-Making12min

7.8 Hack a Jordan (or Dwight)4min

13 leituras

Download Excel Files (Important!)10min

Excel Files10min

Homework Problem 2410min

Excel Files10min

Homework Problem 2510min

Excel Files10min

Homework Problem 2610min

Excel Files10min

Homework Problem 2710min

4 exercícios práticos

Test 242min

Test 254min

Test 262min

Test 272min

Semana

8

5 horas para concluir

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 vídeos (Total 88 mín.), 18 leituras, 5 testes

7 videos

8.1 Rating NFL teams18min

8.2 Computing Strength of Schedule11min

8.3 Rating NFL Offenses and Defenses11min

8.4 Multiplicative Rating Models for Soccer17min

8.5 Regularization7min

8.6 Simulating the NCAA Tournament12min

8.7 NCAA Props Bets8min

18 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Homework Problem 2810min

Excel Files10min

Recommended Reading10min

Homework Problem 2910min

Excel Files10min

Recommended Reading10min

Homework Problem 3010min

Excel Files10min

Recommended Reading10min

Homework Problem 3110min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 3210min

5 exercícios práticos

Test 282min

Test 292min

Test 302min

Test 312min

Test 322min

Semana

9

5 horas para concluir

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 vídeos (Total 97 mín.), 19 leituras, 4 testes

10 videos

9.1 Method of Maximum Likelihood9min

9.2 Rating Teams Based on Wins and Losses9min

9.3 Simulating the NFL Playoffs4min

9.4 Rating NASCAR Drivers10min

9.5 How Good are NFL Point Spreads15min

9.6 Relating the Money Line to Point Spreads9min

9.7 How Can you tell if a Betting System is Successful?11min

9.8 Props Bets I11min

9.9 Props Bet II10min

9.10 Props Bet III5min

19 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Recommended Reading10min

Homework Problem 3310min

Excel Files10min

Recommended Reading10min

Homework Problem 3410min

Excel Files10min

Homework Problem 3510min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 3610min

4 exercícios práticos

Test 332min

Test 342min

Test 352min

Test 362min

Semana

10

4 horas para concluir

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 vídeos (Total 73 mín.), 14 leituras, 4 testes

7 videos

10.1 Kelly Growth Part I10min

10.2 Kelly Growth Part II5min

10.3 Kelly Growth Part III6min

10.4 Regression to the Mean14min

10.5 Daily Fantasy Sports Part I8min

10.6 Daily Fantasy Sports Part II18min

10.7 Golf Analytics10min

14 leituras

Download Excel Files (Important!)10min

Excel Files10min

Recommended Reading10min

Excel Files10min

Homework Problem 3710min

Excel Files10min

Recommended Reading10min

Homework Problem 3810min

Excel Files10min

Homework Problem 3910min

Excel Files10min

Homework Problem 4010min

4 exercícios práticos

Test 372min

Test 382min

Test 392min

Test 402min

Semana

11

1 hora para concluir

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 leitura, 1 teste

1 leituras

Download Excel Files10min

1 exercício prático

Final Exam20min

Instrutores

Professor Wayne Winston

Visiting Professor

Bauer College of Business

Perguntas Frequentes – FAQ

Quando terei acesso às palestras e às tarefas?
Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.
O que recebo ao adquirir o Certificado?
Quando você adquire o Certificado, ganha acesso a todo o material do curso, incluindo avaliações com nota atribuída. Após concluir o curso, seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.
Qual é a política de reembolso?
Existe algum auxílio financeiro disponível?

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.

A matemática por trás do Moneyball