logo image
James Galbraith LBJ School UT Austin Levy Institute EPS thanks


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

Stack-Bar Graph
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.

about UTIP
working papers
data sets
research group