About this Course
7,976

100% 온라인

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

탄력적인 마감일

일정에 따라 마감일을 재설정합니다.

초급 단계

완료하는 데 약 16시간 필요

영어

자막: 영어

귀하가 습득할 기술

StatisticsAnalyticsMicrosoft ExcelProbability

100% 온라인

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

탄력적인 마감일

일정에 따라 마감일을 재설정합니다.

초급 단계

완료하는 데 약 16시간 필요

영어

자막: 영어

강의 계획 - 이 강좌에서 배울 내용

1
완료하는 데 3분 필요

Before you start...

...
1 video (Total 2 min), 1 reading
1개의 동영상
1개의 읽기 자료
Suggested Textbooks (Not Required)1m
완료하는 데 5시간 필요

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 min), 22 readings, 3 quizzes
11개의 동영상
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개의 읽기 자료
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개 연습문제
Test Questions 1 and 24m
Test Question 32m
Test Question 42m
2
완료하는 데 5시간 필요

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 min), 23 readings, 2 quizzes
10개의 동영상
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개의 읽기 자료
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개 연습문제
Test Question 52m
Test Question 62m
3
완료하는 데 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 (Total 71 min), 10 readings, 2 quizzes
6개의 동영상
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개의 읽기 자료
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개 연습문제
Test Question 72m
Test Question 82m
4
완료하는 데 6시간 필요

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 min), 27 readings, 5 quizzes
13개의 동영상
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개의 읽기 자료
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개 연습문제
Test Question 92m
Test Questions 10&114m
Test Question 122m
Test Question 132m
Test Question 142m
5
완료하는 데 6시간 필요

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 min), 23 readings, 5 quizzes
11개의 동영상
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개의 읽기 자료
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개 연습문제
Test Question 152m
Test Question 162m
Test Question 172m
Test Question 182m
Test Question 192m
6
완료하는 데 4시간 필요

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 min), 16 readings, 4 quizzes
7개의 동영상
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개의 읽기 자료
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개 연습문제
Test Question 202m
Test Question 212m
Test Question 222m
Test Question 232m
7
완료하는 데 4시간 필요

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 min), 13 readings, 4 quizzes
8개의 동영상
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개의 읽기 자료
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개 연습문제
Test 242m
Test 254m
Test 262m
Test 272m
8
완료하는 데 5시간 필요

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 min), 18 readings, 5 quizzes
7개의 동영상
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개의 읽기 자료
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개 연습문제
Test 282m
Test 292m
Test 302m
Test 312m
Test 322m
9
완료하는 데 5시간 필요

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 min), 19 readings, 4 quizzes
10개의 동영상
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개의 읽기 자료
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개 연습문제
Test 332m
Test 342m
Test 352m
Test 362m
10
완료하는 데 4시간 필요

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 min), 14 readings, 4 quizzes
7개의 동영상
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개의 읽기 자료
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개 연습문제
Test 372m
Test 382m
Test 392m
Test 402m
11
완료하는 데 1시간 필요

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개의 읽기 자료
Download Excel Files10m
1개 연습문제
Final Exam20m
4.5
9개의 리뷰Chevron Right

최상위 리뷰

대학: 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.

강사

Avatar

Professor Wayne Winston

Visiting Professor
Bauer College of Business

휴스턴 시스템 대학교 정보

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

자주 묻는 질문

  • 강좌에 등록하면 바로 모든 비디오, 테스트 및 프로그래밍 과제(해당하는 경우)에 접근할 수 있습니다. 상호 첨삭 과제는 이 세션이 시작된 경우에만 제출하고 검토할 수 있습니다. 강좌를 구매하지 않고 살펴보기만 하면 특정 과제에 접근하지 못할 수 있습니다.

  • 수료증을 구매하면 성적 평가 과제를 포함한 모든 강좌 자료에 접근할 수 있습니다. 강좌를 완료하면 전자 수료증이 성취도 페이지에 추가되며, 해당 페이지에서 수료증을 인쇄하거나 LinkedIn 프로필에 수료증을 추가할 수 있습니다. 강좌 콘텐츠만 읽고 살펴보려면 해당 강좌를 무료로 청강할 수 있습니다.

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.