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

Excel Basics: Doing Calculations

This tutorial demonstrates basic calculations in Excel using 2000 Census data, including: entering formulas; copying and pasting; anchoring formulas; filling cells; and formatting cells.

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