Lecture videos for Dr. Jerz's Business Analytics undergraduate online course. Note: This podcast is "refreshed" each semester, meaning that I remove most episodes except the introductory episodes. This course starts in June 2020 and runs for 8 weeks. Note: I do try to improve the episodes as often as I can, so you might want to re-download episodes occasionally.
| Who is Dr. Jerz? |
An introduction to the professor for this course.
 
|
| Videos, Videos, and More Videos |
| Describes the variety of videos and ways to view them. View this video before the first class day.
|
| Overview of Moodle |
| This video shows you all the features of Moodle that we will be using in this course.
|
| Course Introduction Video |
| This video should be viewed before the first class day.
|
| T01 Lecture: What is Statistics? |
| Dr. Jerz's lecture provides an overview of business statistics.
|
| Excel Overview and Fundamentals |
| This is Dr. Jerz's lecture that provides an overview of Microsoft Excel. This video mixes both beginner (background) information along with some advanced methods, so there should be something in it for everyone.
|
| T02 Lecture: Describing Data Graphically. |
| Dr. Jerz's lecture on describing data graphically.
|
| T02 Excel: Graphing Techniques |
| Dr. Jerz's lecture that illustrates how to create graphs using Excel. This video mixes both beginner information along with some advanced graphing methods, so there should be something in it for everyone.
|
| T03 Lecture: Describing Data Numerically |
| Dr. Jerz's lecture on describing data numerically. We explore both central tendency statistics, and dispersion statistics.
|
| T03 Excel: Descriptive Statistics |
| Dr. Jerz's video showing his Excel model for calculating descriptive statistics.
|
| T04 Lecture: Other ways to describe data dispersion. |
| Dr. Jerz's lecture on describing a few other ways to describe data dispersion both graphically and numerically.
|
| T04 Excel: Other ways to describe data dispersion. |
| Dr. Jerz's shows how to do some other ways to describe data dispersion using Excel.
|
| T04 Excel: Tables_and_PivotTable. |
| Dr. Jerz's shows how to work with tables in Excel. |
| T05 Importing_Cleaning_Data - Part 1 |
| Dr. Jerz shows how to import and clean data using Excel, Part 1.
|
| T05 Importing_Cleaning_Data - Part 2 |
| Dr. Jerz shows how to import and clean data using Excel, Part 2
|
| T06 Chi-square Goodness of Fit Tests |
| Dr. Jerz's lecture that describes how to perform Chi-Square tests to determine if a frequency distribution matches an expected multinominal, uniform, or normal distribution.
|
| T06 Excel: Chi-square Goodness of Fit Tests |
| Dr. Jerz's illustrates how to use his Excel model to perform goodness of fit tests.
|
| T07 Lecture: Chs 11 and 12, Two-Sample Tests |
| Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses.
|
| T07 Excel: Chs 11 and 12 Two-Sample Tests |
| Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses using Excel.
|
| T09 Lecture: Correlation and Linear Regression. |
| Dr. Jerz's lecture on correlation and linear regression analysis.
|
| T09 Excel: Correlation and Linear Regression. |
| Dr. Jerz shows how to use his Excel model for correlation and linear regression.
|
| T10 Lecture: Ch14, Multiple Regression |
| Dr. Jerz's lecture on multiple regression.
|
| T10 Excel: Ch14, Multiple Regression. |
| Dr. Jerz shows how to use his Excel model for multiple regression.
|
| T11: Forecasting |
| Dr. Jerz's lecture on Forecasting.
|
| T11: Using Excel for Forecasting |
| Dr. Jerz's lecture on Forecasting in Excel.
|
| T12 Getting Started with Tableau |
| This is Tableau's Getting Started video from their website. I provide this here as a convenience.
|
| T12: Tableau: Basic Statistical Charts |
| Dr. Jerz illustrates how to recreate some of Excel's basic charts for statistics using Tableau.
|
| T13: Tableau II |
| Dr. Jerz's lecture on Tableau's additional visualizations.
|
| T14: VBA_Pivot_Tableau_III |
| Dr. Jerz's lecture on User-defined functions, PivotTables and Slices, and Regression in Tableau.
|
| End of Semester - Summary Video |
| This video summarizes our semester together and provides a few closing comments.
|