This video summarizes our semester together and provides a few closing comments.
Dr. Jerz illustrates how to recreate some of Excel's basic charts for statistics using Tableau.
This is Tableau's Getting Started video from their website. I provide this here as a convenience.
Dr. Jerz shows how to use his Excel model for multiple regression.
Dr. Jerz shows how to use his Excel model for correlation and linear regression.
Dr. Jerz's lecture on correlation and linear regression analysis.
Dr. Jerz's illustrates how to use his Excel model to perform goodness of fit tests.
Dr. Jerz's lecture that describes how to perform Chi-Square tests to determine if a frequency distribution matches an expected multinominal, uniform, or normal distribution.
Dr. Jerz shows how to import and clean data using Excel, Part 2
Dr. Jerz shows how to import and clean data using Excel, Part 1.
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses using Excel.
Dr. Jerz's lecture that describes how to perform two-sample tests of hypotheses.
Dr. Jerz's shows how to do some other ways to describe data dispersion using Excel.
Dr. Jerz's lecture on describing a few other ways to describe data dispersion both graphically and numerically.
Dr. Jerz's video showing his Excel model for calculating descriptive statistics.