UW CAE Learning Project

Testing Video Links

All Site Content

The Tutorial Videos were made by Timothy Welnetz. Here is a short bio about Timothy:

I taught statistics courses at UW-Madison beginning in 1995 where I served as a senior lecturer in the School of Business. In addition to teaching, I had been a senior research specialist at UW's Center for Health Policy and Program Evaluation, mostly involved with adolescent/adult alcohol and drug prevention and pregnancy prevention programs. I also worked on other evaluation projects for organizations outside of the university, and before coming to the university, I worked for several years in the actuarial department at American Family Insurance.

For complete data description, click here.

Video#	Video Title	Topic	Data Set	Description
Video 01	Make a Percent Histogram Flash version	Univariate Analysis	Retail_Sales	Sort data, create bins, create histogram, create percent column, select data and change scales
Video 02	Make a Summary Statistics Table Flash version	Univariate Analysis	Bodily_Injury	Get descriptive data, find quartiles in Excel, edit format
Video 03	Make a Dotplot Flash version	Univariate Analysis	House_Prices	Sort data, create frequency column and scatter plot, edit and get dot plot
Video 04	Make a Dotplot Using Rounded Values Flash version	Univariate Analysis	Retail_Sales	Sort data, create frequency column and scatter plot, get rounded values, select data and get dot plot
Video 05	Create a Histogram with a Correct X-Axis Scale Flash version	Univariate Analysis	House_Prices	Sort data, create bins, create histogram, correct X-axis scale
Video 06	Create a Presentation-Quality Scatterplot Flash version	Bivariate Analysis	House_Prices	Select x and y data, insert scatter plot and edit
Video 07	Make a Scatter Plot Matrix Flash version	Bivariate Analysis	Palse_Rates	Select data, make scatter plots for each two variables, add label and edit the layout
Video 08	Make a Scatter Plot with Groups Flash version	Bivariate Analysis	Apartment_Rent_2010	Rescale variables, split data by west and south, find descriptive statistics for each group, draw scatter plot for one group and add data series for the other
Video 09	Make a Time-Series Plot Flash version	Time Series Analysis	Retail_Sales	Make scatter plot using month index, format X-axis and edit the plot
Video 10	Make a Time-Series Plot with Data Lables by the Points Flash version	Time Series Analysis	Retail_Sales	Create new month label column, make scatter plot, add labels and format the layout
Video 11	Run Test in Time-Series Flash version	Time Series Analysis	Gas_Use	Calculate the average, create binary variable, create counting runs column, calculate z statistics and p-value
Video 12	Make an Individuals Control Flash version	Time Series Analysis	Gas_Use	create moving range, UCL, CL, LCL column, insert scatter plot and edit
Video 13	Make a Moving Range Control Chart Flash version	Time Series Analysis	Gas_Use	Create UCL and CL for moving range, insert scatter plot and edit
Video 14	Create a Random Process Fitted Line Plot Flash version	Time Series Analysis	Gas_Use	Find the average value and calculate residuals, insert scatter plot, calculate mean squared deviation and root mean square error
Video 15	Make a Moving Average Plot Flash version	Time Series Analysis	Gas_Use	Create smoothed values and forcasted values, calculate residuals, insert scatter plot, calculate MSD and RMSE
Video 16	Make an Exponentially-Weighted Moving Average Plot Flash version	Time Series Analysis	Gas_Use	Determine the start point of forcasted values, determine alpha and calculate smoothed values and residuals, insert scatter plot, calculate MSD and RMSE
Video 17	Assess Whether a Time-Series Follows a Random Walk Flash version	Time Series Analysis	Gas_Use	Insert time-series scatter plot, create difference column and make another time-series scatter plot, find summary statistices, do a point forecast
Video 18	Simple Regression Basics Flash version	Basic Regression	Ice_Cream_Sales	Make scatter plot, add trend line and equation, run regression, result analysis
Video 19	Doing a T-Test on the Slope of Coefficient in Simple Regression Flash version	Basic Regression	Ice_Cream_Sales	Run regression, specify hypotheses, find test statistc, quantify the evidence of the test, determine criteical region and p-value
Video 20	Creating a Confidence Interval for the Slope of a Simple Regression Flash version	Basic Regression	Ice_Cream_Sales	Run regression, find the slope, t-value and standard error
Video 21	Prediction in Simple Regression Flash version	Basic Regression	Ice_Cream_Sales	Run regression, find the regression equation, determine desired prediction level, find point predition and lower/upper bound of the prediction interval
Video 22	Assess the Impact of an Outlier in a Simple Regression Analysis Flash version	Basic Regression	Retail_Sales	Run regression, show residual output, delete the outlier and run regression again, compare the slope, intercept, R-sqare and standard error
Video 23	Residual Analysis of Simple Regression Flash version	Basic Regression	Retail_Sales	Run regression, show residual output and determine outlier, check residual plot
Video 24	Run a Quadratic Regression Flash version	Multiple Regression	Retail_Sales	Add ploynomial treand line to the scatter plot, create new column temp-squared, run regression again, draw temp-squared fit plot and resicual plot
Video 25	Run a Multiple Regression Flash version	Multiple Regression	Palse_Rates	Make a correlation matix, run regression, find the equation, results interpretation
Video 26	Make Predictions from a Multiple Regression Analysis Flash version	Multiple Regression	Palse_Rates	Find point prediction using equation, find standard error and t-value, find lower/upper bound
Video 27	Check the Assumption in Multiple Regression Part I-Independence Assumption Flash version	Multiple Regression	Pulse_Rates	Run regression, make residual vs predictive variable plots, make time-series plot
Video 28	Check the Assumption in Multiple Regression Part II-Constant Variance Flash version	Multiple Regression	Pulse_Rates	Make residual vs predicted value plot, add a straight line, add polunomial trend line and observe the shape
Video 29	Check the Assumptions in Multiple Regression Part III-Normality Assumption Flash version	Multiple Regression	Pulse_Rates	Find rounded and sorted standard residuals, find the frequency, draw and format dot plot
Video 30	Check a Normal Probability Plot Flash version	Multiple Regression	Pulse_Rates	Run regression and show residual output, find rank, proportion, z-value and sort residuals, make z-value vs residual scatter plot
Video 31	Calculate Variance Inflation Factors Flash version	Multiple Regression	Pulse_Rates	Run regression, review VIF formula, find descriptive summaries, find st deviation and find VIF for each variable
Video 32	Relate Two Metric Variables and One Binary Variables in a Scatterplot Flash version	Multiple Regression	Apartment_Rent_2010	Split the datat into two parts according to location, draw scatter plot and add data series, find descriptive statistics for each part
Video 33	Parallel Lines Regression Analysis Flash version	Multiple Regression	Apartment_Rent_2010	Turn location into a binary variable, run regression and give equation for each location
Video 34	Parallel Lines Fitted Lines Plot Flash version	Multiple Regression	Apartment_Rent_2010	Find fitted value for each location, insert scatter plot, add the fitted line for each location
Video 35	Nonparallel Lines Regression Analysis Flash version	Multiple Regression	Apartment_Rent_2010	Create new interaction variable, run regression and find equation for each location
Video 36	Nonparallel Lines Fitted Lines Plot Flash version	Multiple Regression	Apartment_Rent_2010	Draw scatter plot and add trend lines and equations, analysis about the interaction term