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.