Business Analytics Administrative Videos

Extra items, such as answer-to-questions videos or extra-note videos, for the Business Analytics course.

Coming Soon
No administrative videos are available yet.

Ch02-Excel-Fill Down Using Mouse
Filling down has changed a little in the latest version of Excel 365.

Ch03-Price_Per_Ton
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.