Support items, such as lecture videos, for the Business Analytics course.

Coming Soon

No administrative videos are available yet.

Ch02-Excel-Fill Down Using Mouse

x Filling down has changed a little in the latest version of Excel 365.

Ch03-Price_Per_Ton

x A student asked for some help in solving this problem.

Ch03-Defined_Name_Ranges versus B:B referencing

In class, we had some discussion about "named ranges" versus B:B type referencing. Here are some of my thoughts about these referencing alternatives.

Ch04-Excel's Percentile Functions

Dr. Jerz explains some differences between Excel's Percentile functions.

Ch05-Number_of_Colors_for_35

A student asked for some help in solving this problem.

Ch06-Tennis_Match

A student asked for some help in solving this problem.

Ch06-Variance and Mean of a Probability Distributions

A student asked for some help solving this problem.

Ch07-Mileage Guarantee Question

A student asked for some help solving this problem.

Ch07-Upper_25_percent_test_scores

A student asked for some help in solving this problem.

Ch07-Flight Attendant Pay

A student asked for some help in solving this problem.

Ch09-Sample Size Local Retail Company

Dr. Jerz shows how to solve this question involving sample size for the local retail company.

Ch10-Tuition_Cost

A student asked for some help in solving this problem.

Ch10-Birth_weights_increased

A student asked for some help in solving this problem.

Ch10-33_American_Household_Interest

A student asked for some help in solving this problem.

Ch11-Women and Men's Savings

A student asked for some help in solving this problem.

Ch14-Insert/Delete Rows in Multiple Regression, Slowly

Dr. Jerz demonstrates how to insert and delete rows in the multiple regression model, slowly.

Ch14-Bertsimas 6.1

Dr. Jerz solves the extra Bertsimas 6.1 multiple regression problem.

Ch14-Bertsimas 6.3

Dr. Jerz solves the extra Bertsimas 6.3 multiple regression problem.