Acerca de este Curso
4.5
39 calificaciones
9 revisiones
100 % en línea

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.
Nivel principiante

Nivel principiante

Horas para completar

Aprox. 15 horas para completar

Sugerido: 3 hours/week...
Idiomas disponibles

Inglés (English)

Subtítulos: Inglés (English)

Habilidades que obtendrás

StatisticsAnalyticsMicrosoft ExcelProbability
100 % en línea

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.
Nivel principiante

Nivel principiante

Horas para completar

Aprox. 15 horas para completar

Sugerido: 3 hours/week...
Idiomas disponibles

Inglés (English)

Subtítulos: Inglés (English)

Programa - Qué aprenderás en este curso

Semana
1
Horas para completar
3 minutos para completar

Before you start...

...
Reading
1 video (Total 2 min), 1 reading
Video1 videos
Reading1 lecturas
Suggested Textbooks (Not Required)1m
Horas para completar
5 horas para completar

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 lecturas
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 ejercicios de práctica
Test Questions 1 and 24m
Test Question 32m
Test Question 42m
Semana
2
Horas para completar
5 horas para completar

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 lecturas
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 ejercicios de práctica
Test Question 52m
Test Question 62m
Semana
3
Horas para completar
3 horas para completar

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 lecturas
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 ejercicios de práctica
Test Question 72m
Test Question 82m
Semana
4
Horas para completar
6 horas para completar

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 lecturas
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 ejercicios de práctica
Test Question 92m
Test Questions 10&114m
Test Question 122m
Test Question 132m
Test Question 142m

Instructores

Avatar

Professor Wayne Winston

Visiting Professor
Bauer College of Business

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

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • Cuando compras un Certificado, obtienes acceso a todos los materiales del curso, incluidas las tareas calificadas. Una vez que completes el curso, se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes participar del curso como oyente sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.