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.
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...
This is a walk through of correcting the error when using the DCOUNT and DAVERAGE formulas with a named table.
Bar Charts in Excel: Here is a monster macro I made in Excel 2010 that takes raw data extracted from a Sharepoint database on the web and creates a beautiful looking Bar Chart
Me covering the use of VLOOKUP when using two lookup values and the built-in excel features called 'Text to columns', 'Remove Duplicates' and 'Subtotal'.
How to create a Drop Down List in Excel 2010
This video shows you how to go from a frequency (pivot) table to calculating a chi-squared statistic.
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...
Abnel's brief introduction video in English
Adding Colors to spreadsheet tabs in Microsoft Excel is a great way to differentiate your spreadsheets for easier identification.
Watch how to use Microsoft Excel to calculate percentages and create a pie chart.