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

Coming Soon
No administrative videos are available yet.
Button to play video Button to download video

Ch02-Frequency Function Slow
Some students asked if I could show how to use the the FREQUENCY() function, slowly. Here it is.
Button to play video Button to download video

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

Ch02-Excel-F11-Quick-Chart_and_shift-ctrl-down
Quick chart using F11 and shift-ctrl-down to quickly highlight a data range.
Button to play video Button to download video

Ch03-Defined_Name_Ranges
In class, we had some discussion about "named ranges" versus B:B type referencing. Here are some of my thoughts about these referencing alternatives.
Button to play video Button to download video

Ch03-Price_Per_Ton
A student asked for some help in solving this problem.
Button to play video Button to download video

Using the UIowa Virtual Desktop Server
Using the UIowa Virtual Desktop Server for TreePlan.
Button to play video Button to download video

Ch04-Create_Box_Plot_in_Excel
In class, a student asked how I created the Box Plot in the Descriptive Statistics model. Here is how I did it.
Button to play video Button to download video

Ch05-Number_of_Colors_for_35
A student asked for some help in solving this problem.
Button to play video Button to download video

Ch06-Tennis_Match
A student asked for some help in solving this problem.
Button to play video Button to download video

Ch06-Variance and Mean of a Probability Distributions
A student asked for some help solving this problem.
Button to play video Button to download video

Ch07-Upper_25_percent_test_scores
A student asked for some help in solving this problem.
Button to play video Button to download video

Ch07-Class_Grades_Greater_Than_C
A student asked for some help solving this problem.
Button to play video Button to download video

Ch07-Mileage Guarantee Question
A student asked for some help solving this problem.
Button to play video Button to download video

Ch07-Observe_a_Negative_Value Question
A student asked for some help solving this problem.
Button to play video Button to download video

Ch10-Tuition_Cost
A student asked for some help in solving this problem.
Button to play video Button to download video

Ch10-Birth_weights_increased
A student asked for some help in solving this problem.
Button to play video Button to download video