University of Texas at Austin

University of Texas Inequality Project

University of Texas at Austin
Lyndon B. Johnson School of Public Affairs


Below are some tools that can be used to create macros and graphs for components of Theil's T statistic:

S No. Title Description
1 Macros in Excel This macro in Excel will calculate the between-groups and within-groups components of Theil's T statistic in Excel for a two-level hierarchical grouping structure (regions and industries). The user will have to copy and paste the data of two variables (population and compensation) into the macro.
2 Stack-Bar Graph (Español) This presentation shows how to create a 'Stack-Bar' graph. This graph is a good visual tool to observe the evolution of the components of a Theil statistic over time.

** The documents and tools are made available by the UTIP research team.