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 XAxis Scale
Flash version

Univariate Analysis 
House_Prices 
Sort data, create bins, create histogram, correct Xaxis scale 
Video 06
 Create a PresentationQuality 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 TimeSeries Plot
Flash version

Time Series Analysis 
Retail_Sales 
Make scatter plot using month index, format Xaxis and edit the plot 
Video 10
 Make a TimeSeries 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 TimeSeries
Flash version

Time Series Analysis 
Gas_Use 
Calculate the average, create binary variable, create counting runs column, calculate z statistics and pvalue 
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 ExponentiallyWeighted 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 TimeSeries Follows a Random Walk
Flash version

Time Series Analysis 
Gas_Use 
Insert timeseries scatter plot, create difference column and make another timeseries 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 TTest 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 pvalue 
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, tvalue 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, Rsqare 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 tempsquared, run regression again, draw tempsquared 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 tvalue, find lower/upper bound 
Video 27
 Check the Assumption in Multiple Regression Part IIndependence Assumption
Flash version

Multiple Regression 
Pulse_Rates 
Run regression, make residual vs predictive variable plots, make timeseries plot 
Video 28
 Check the Assumption in Multiple Regression Part IIConstant 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 IIINormality 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, zvalue and sort residuals, make zvalue 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 