Search 75,786 tutors

# Creating A Scatter Plot using Microsoft Excel

Creating a scatter plot after breaking some econometric data into two groups. Basic "White-belt" level.

# Multiple Linear Regression Analysis in Microsoft Excel Part I

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.

# Adding-In the Excel Analysis Toolpak

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....

# Performing a "What-If" Analysis on Spreadsheets Using MS Excel's Scenario Manager

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...

# Excel Formulas - DCOUNT and DAVERAGE

This is a walk through of correcting the error when using the DCOUNT and DAVERAGE formulas with a named table.

# Monster Excel Macro

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

# Microsoft Excel Help: VLOOKUP

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 Microsoft Excel 2010 tutorial

How to create a Drop Down List in Excel 2010

# Stats in Excel Lesson 4: Making a Chi-squared Statistic

This video shows you how to go from a frequency (pivot) table to calculating a chi-squared statistic.

# Stats in Excel Lesson 3: Making a Frequency Pivot Table

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.

# Stats in Excel Lesson 2: Summary Statistics

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...

# Stats in Excel Lesson 1: Making Fake Data

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...