A quick look at some of the more important numbers provided by Excel in the summary output for a multiple regression analysis. This video can reinforce basic understanding of multiple regression analysis, but is not intended to be an introduction...
How to do a multiple regression analysis of data in an Excel worksheet. If you have not done so already, you will need to add-in the analysis toolpak as described in that video. This video is basic "Yellow-belt" Excel.
Excel's built-in statistical functions can be supplemented with the Analysis Toolpak. If you are not sure how to load an Add-In into Excel, this video demonstrates the simple technique and shows you how to get started with the Analysis Toolpak....
These are some of my online recorded lectures on Data Analysis Using SPSS, Matlab and Stata. I have taught Econometrics, Statistics and Mathematicsl to graduate and undergraduate students at university level.
In this video, I show how to make a frequency table using the Pivot Table option in Excel. This will be needed before doing a chi-squared statistics, which is shown in my next video.
In this video, I use fake data from Lesson 1 to do summary statistics in Excel. Using a fake continuous variable, we calculate mean (average), standard deviation, count of observations, and then calculate a standard error. From this, we develop a...
In this video, I show tips for making fake data. Fake data are useful for testing your understanding of certain statistical concepts, but are not actually that easy to make. The fake data made in this video will be used in subsequent videos to demonstrate...