Lecture videos for Dr. Jerz's Business Analytics online course. Note: This podcast is "refreshed" each semester, meaning that I remove most episodes except the introductory episodes.
This video summarizes our semester together and provides a few closing comments.
Dr. Jerz's lecture on Tableau's additional visualizations.
Dr. Jerz illustrates how to recreate some of Excel's basic charts for statistics using Tableau.
This is Tableau's Getting Started video from their website. I provide this here as a convenience.
Dr. Jerz shows how to use his Excel model for multiple regression.
Dr. Jerz's lecture on multiple regression.
Dr. Jerz shows how to use his Excel model for correlation and linear regression.
Dr. Jerz's lecture on correlation and linear regression analysis.
Dr. Jerz shows how to import and clean data using Excel, Part 2
Dr. Jerz shows how to import and clean data using Excel, Part 1.
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses using Excel.
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses.
Dr. Jerz's shows how to work with tables in Excel.
Dr. Jerz's shows how to do some other ways to describe data dispersion using Excel.
Dr. Jerz's lecture on describing a few other ways to describe data dispersion both graphically and numerically.
Dr. Jerz's video showing his Excel model for calculating descriptive statistics.
Dr. Jerz's lecture on describing data numerically. We explore both central tendency statistics, and dispersion statistics.
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.
Dr. Jerz's lecture on describing data graphically.
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.
Dr. Jerz's lecture provides an overview of business statistics.
This video should be viewed before the first class day.
This video shows you all the features of Moodle that we will be using in this course.
Describes the variety of videos and ways to view them. View this video before the first class day.
This video summarizes our semester together and provides a few closing comments. Transcript (srt) file: MSCI2800 Semester End
Dr. Jerz's lecture on User-defined functions, PivotTables and Slices, and Regression in Tableau. Transcript (srt) file: VBA_Pivot_Tableau_III
Dr. Jerz's lecture on Tableau's additional visualizations. Transcript (srt) file: Tableau_II
Dr. Jerz illustrates how to recreate some of Excel's basic charts for statistics using Tableau. Transcript (srt) file: Tableau_Basics
Dr. Jerz's lecture on Forecasting in Excel. Transcript (srt) file: Excel_Forecasting
Dr. Jerz's lecture on Forecasting. Transcript (srt) file: Forecasting
Dr. Jerz shows how to use his Excel model for multiple regression.Transcript (srt) file: Excel-Multiple_Regression
Dr. Jerz's lecture on multiple regression.Transcript (srt) file: Multiple_Regression
Dr. Jerz shows how to use his Excel model for correlation and linear regression.Transcript (srt) file: Excel-Correlation_Regression
Dr. Jerz's lecture on correlation and linear regression.Transcript (srt) file: Correlation_and_Regression_Analysis
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses using Excel.Transcript (srt) file: Excel-Two-Sample_Tests
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses.Transcript (srt) file: Two-Sample_Tests
Dr. Jerz's illustrates how to use his Excel model to perform goodness of fit tests.Transcript (srt) file: Excel-Chi-Square_Test
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.Transcript (srt) file: Chi-Square_Test
Dr. Jerz's reviews some of the ways to import data, and a few other features from our project.Transcript (srt) file: Excel-Importing_Data
Dr. Jerz's shows how to work with tables in Excel.Transcript (srt) file: Excel-Tables_and_PivotTable
Dr. Jerz's shows how to do some other ways to describe data dispersion using Excel.Transcript (srt) file: Excel-Dispersion
Dr. Jerz's lecture on describing a few other ways to describe data dispersion both graphically and numerically.Transcript (srt) file: Dispersion
Dr. Jerz's video showing his Excel model for calculating descriptive statistics.Transcript (srt) file: Excel-Descriptive_Statistics
Dr. Jerz's lecture on describing data numerically. We explore both central tendency statistics, and dispersion statistics.Transcript (srt) file: Descriptive_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.Transcript (srt) file: Excel-Graphing_Techniques
Dr. Jerz's lecture on describing data graphically.Transcript (srt) file: Graphing_Techniques
Dr. Jerz's lecture provides an overview of business statistics.Transcript (srt) file: What_is_Statistics
This video shows you all the features of Moodle that we will be using in this course.Transcript (srt) file: Moodle_Overview.srt
Describes the variety of videos and ways to view them. View this video before the first class day.Transcript (srt) file: Videos-Videos-Videos
An introduction to the professor for this course.Transcript (srt) file: Who_Is_Dr._Jerz.srt
© 2020-2025 Ivy Podcast Discovery LLC
