These are the lecture videos currently released for Dr. Jerz's Business Analytics course. I provide a link to the video and a short description for each episode.
| 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. |
| An 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. |
| Ch01 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. |
| Ch02 Lecture: Describing Data Graphically |
| Dr. Jerz's lecture on describing data graphically. |
| Ch02 Excel: Describing Data Graphically |
| 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. |
| Ch03 Lecture: Describing Data Numerically |
| Dr. Jerz's lecture on describing data numerically. We explore both central tendency statistics, and dispersion statistics. |
| Ch03 Excel: Describing Data Numerically |
| Dr. Jerz's video showing his Excel model for calculating descriptive statistics. |
| Ch04 Lecture: Additional Dispersion Methods |
| Dr. Jerz's lecture on describing a few other ways to describe data dispersion both graphically and numerically. |
| Ch04 Excel: Additional Dispersion Methods |
| Dr. Jerz's shows how to do some other ways to describe data dispersion using Excel. |
| WK02 Lecture: Decision Analysis and Decision Trees |
| This video is Dr. Jerz's lecture about decision analysis and decision trees. |
| WK02 Excel: Decision Trees |
| Dr. Jerz creates decision trees in Excel and illustrates TreePlan. |
| WK03 Lecture: Probability |
| Dr. Jerz's lecture on probability. |
| WK03 Excel: Probability |
| Dr. Jerz shows how to use Excel for doing arrangement, permutation, and combination calculations. |
| WK04 Discrete Probability Distributions |
| Dr. Jerz's lecture on the discrete probability distributions. |
| WK04 Excel: The Binomial Distribution model. |
| Dr. Jerz shows how to use the Binomial function Excel model to solve some binomial probability problems. |
| WK05 Lecture: Ch7, The Normal Probability Distribution. |
| Dr. Jerz's lecture on the normal probability distribution. |
| WK05 Excel: Ch7, The Normal Probability Distribution |
| Dr. Jerz explains how to use his Excel model for normal distribution calculations. |
| WK06 Lecture: Ch8, Sampling Methods and the Central Limit Theorem. |
| Dr. Jerz's lecture on sampling methods and the Central Limit Theorem. |
| WK06 Excel: Ch8, Model for Sampling Methods and the Central Limit Theorem. |
| Dr. Jerz shows how to use his Excel model for sampling methods. |
| WK06 Lecture: Ch9, Estimation and Confidence Limits. |
| Dr. Jerz's lecture on confidence limits. |
| WK06 Excel: Ch9, Confidence Limits. |
| Dr. Jerz shows how to use his Excel model calculating confidence limits and sample size. |
| WK07 Lecture: Ch10, Hypothesis Testing. |
| Dr. Jerz's lecture on one-sample hypothesis testing of the mean. |
| WK07 Excel: Ch10, Hypothesis Testing. |
| Dr. Jerz's lecture on using Excel for one-sample hypothesis testing of the mean. |
| WK07 Lecture: Chs 11 and 12, Two-Sample Tests |
| Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses. |
| WK07 Excel: Chs 11 and 12 Two-Sample Tests |
| Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses using Excel. |
| WK08 Lecture: Ch13, Correlation and Linear Regression. |
| Dr. Jerz's lecture on correlation and linear regression analysis. |
| WK08 Excel: Ch13, Correlation and Linear Regression. |
| Dr. Jerz shows how to use his Excel model for correlation and linear regression. |
| Making Chocolate Chip Cookies |
| Dr. Jerz showing how he makes his world-famous chocolate chip cookies. |
| WK09 Lecture: Ch14, Multiple Regression. |
| Dr. Jerz's lecture on multiple regression. |
| WK09 Excel: Ch14, Multiple Regression. |
| Dr. Jerz shows how to use his Excel model for multiple regression. |
| WK10: Optimization and Simulation |
| Dr. Jerz's lecture on optimization and simulation. |
| WK10: Transportation Model |
| Dr. Jerz's lecture on the transportation model. |
| WK10: Excel Transportation Model |
| This video shows how to solve the transportation problem using Excel. |
| End of Semester - Summary Video |
| This video summarizes our semester together and provides a few closing comments. |