Using American FactFinder

This tutorial demonstrates how to look up data using the Census Bureau’s American FactFinder. The example finds transportation-related data in two cities in Michigan using Census 2000.

Click the image to begin streaming video (5 minutes).

How to Download County Business Patterns Data

This tutorial demonstrates how to download data on establishments and employment from County Business Patterns at the U.S. Bureau of the Census American FactFinder site. The example gathers data on Washtenaw County in 2006 at the 2-digit NAICS level of industrial detail.

Click the image to begin streaming video (4 minutes).

Population Pyramid

This tutorial demonstrates creating a population pyramid in Excel using data from a cohort-component model. An abbreviated set of directions in text can be found by clicking here.

Click the image to begin streaming video (10 minutes).

How to Transfer an Excel Chart to Microsoft Word

This is a tutorial to show how to properly insert a chart created in Excel into a Word document for publication. Have you ever copied-and-pasted an Excel chart to Word and then found yourself trying to fix font sizes by trial and error? What a mess. Then this tutorial is for you. It shows how to properly size and format your chart in Excel prior to transferring to Word.

Click the image to begin streaming video (8 minutes).

Creating an Excel Chart: Comparing Income Inequality with Lorenz Curves

This tutorial demonstrates how to make a chart in Excel, with the example of comparing Lorenz Curves for changes in income inequality between 1967 and 2006 in the United States.

Click the image to begin streaming video (11 minutes).

Measuring Inequality: Calculate Dissimilarity Index

This tutorial demonstrates how to calculate a Dissimilarity Index in Excel. The example uses 2000 Census data to investigate income inequality among municipalities in Berrian County.

Click the image to begin streaming video (6 minutes).

Measuring Inequality: Create an Index

This tutorial demonstrates how to calculate an index, and how to use Excel's conditional formatting to visualize data. The example uses 2000 Census data to investigate income inequality in Berrian County.

Click the image to begin streaming video (6 minutes).