About this Course
4.5
39 ratings
9 reviews
100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Beginner Level

Beginner Level

Hours to complete

Approx. 15 hours to complete

Suggested: 3 hours/week...
Available languages

English

Subtitles: English

Skills you will gain

StatisticsAnalyticsMicrosoft ExcelProbability
100% online

100% online

Start instantly and learn at your own schedule.
Flexible deadlines

Flexible deadlines

Reset deadlines in accordance to your schedule.
Beginner Level

Beginner Level

Hours to complete

Approx. 15 hours to complete

Suggested: 3 hours/week...
Available languages

English

Subtitles: English

Syllabus - What you will learn from this course

Week
1
Hours to complete
3 minutes to complete

Before you start...

...
Reading
1 video (Total 2 min), 1 reading
Video1 video
Reading1 reading
Suggested Textbooks (Not Required)1m
Hours to complete
5 hours to complete

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. ...
Reading
11 videos (Total 90 min), 22 readings, 3 quizzes
Video11 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
Reading22 readings
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
Quiz3 practice exercises
Test Questions 1 and 24m
Test Question 32m
Test Question 42m
Week
2
Hours to complete
5 hours to complete

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. ...
Reading
10 videos (Total 76 min), 23 readings, 2 quizzes
Video10 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
Reading23 readings
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
Quiz2 practice exercises
Test Question 52m
Test Question 62m
Week
3
Hours to complete
3 hours to complete

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....
Reading
6 videos (Total 71 min), 10 readings, 2 quizzes
Video6 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
Reading10 readings
Download Excel Files (Important!)10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Recommended Reading10m
Excel Files10m
Homework Problem 810m
Quiz2 practice exercises
Test Question 72m
Test Question 82m
Week
4
Hours to complete
6 hours to complete

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....
Reading
13 videos (Total 88 min), 27 readings, 5 quizzes
Video13 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
Reading27 readings
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
Quiz5 practice exercises
Test Question 92m
Test Questions 10&114m
Test Question 122m
Test Question 132m
Test Question 142m

Instructor

Avatar

Professor Wayne Winston

Visiting Professor
Bauer College of Business

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

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.