4.5
41 ratings
9 reviews

#### 100% online

Start instantly and learn at your own 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.

#### 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.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
4.5
9 Reviews

### Top Reviews

By 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

### Professor Wayne Winston

Visiting Professor