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