4.5
39 ratings
9 reviews

#### 100% online

Start instantly and learn at your own schedule.

Reset deadlines in accordance to your schedule.

#### Approx. 15 hours to complete

Suggested: 3 hours/week...

#### English

Subtitles: English

### Skills you will gain

StatisticsAnalyticsMicrosoft ExcelProbability

#### 100% online

Start instantly and learn at your own schedule.

Reset deadlines in accordance to your schedule.

#### Approx. 15 hours to complete

Suggested: 3 hours/week...

#### English

Subtitles: English

### Syllabus - What you will learn from this course

Week
1
3 minutes to complete

## Before you start...

...
1 video (Total 2 min), 1 reading
1 video
Suggested Textbooks (Not Required)1m
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. ...
11 videos (Total 90 min), 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
Excel Files10m
Excel file10m
Excel file10m
Excel file10m
Excel Files10m
Homework Problem 310m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problems 410m
3 practice exercises
Test Questions 1 and 24m
Test Question 32m
Test Question 42m
Week
2
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. ...
10 videos (Total 76 min), 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
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problem 510m
Excel Files10m
Excel Files10m
Homework Problem 610m
2 practice exercises
Test Question 52m
Test Question 62m
Week
3
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....
6 videos (Total 71 min), 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
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problem 810m
2 practice exercises
Test Question 72m
Test Question 82m
Week
4
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....
13 videos (Total 88 min), 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
Excel Files10m
Excel Files10m
Homework Problem 910m
Excel Files10m
Excel Files10m
Homework Problem 1010m
Homework Problem 1110m
Excel Files10m
Homework Problem 1210m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problem 1310m
Excel Files10m
Excel Files10m
Excel Files10m
Excel Files10m
Homework Problem 1410m
5 practice exercises
Test Question 92m
Test Questions 10&114m
Test Question 122m
Test Question 132m
Test Question 142m

## Instructor

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