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...
Watch and learn from videos created by private tutors
Excel VideosNewest Most Active
Creating a scatter plot after breaking some econometric data into two groups. Basic "White-belt" level.
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.
An example of how to mix absolute and relative references in a Microsoft Excel formula. Basic "white-belt" level.
How to use the Excel's FREQUENCY() function to create a histogram of your data. Basic "White Belt" Level.
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....
Excel's Scenario Manager conveniently keeps track of several different sets of values that can be plugged into a worksheet to examine the consequence of changes. For example, we might want to examine growth under several potential changes in unemployment...