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