際際滷

際際滷Share a Scribd company logo

T Stat Pres

Download as PPT, PDF
T
timsandle

This document provides instructions for creating a stack-bar graph in Excel to visualize inequality over time across different sectors. It outlines obtaining individual Theil inequality components, transposing a matrix with sectors in rows and years in columns, sorting the sectors from largest to smallest in the base year, and using Excel's sorting and charting tools to generate the final stack-bar graph with sectors in columns and years in rows.

1 of 12
Download to read offline
Measuring Inequality A practical workshop On theory and technique San Jose, Costa Rica August 4 -5, 2004
Panel Session on: How to create a Stack-Bar Graph in Excel
By James K. Galbraith and Enrique Garcilazo The University of Texas Inequality Project Session 6 http://utip.gov.utexas.edu
Outline Obtain the individual between Theil components Create a Matrix Sectors in rows Years in columns Change to a new matrix with transpose command under paste special options we obtain: Sectors in columns Years in rows Sort sectors (with sort command) left to right from larger to smaller in base year (last year) Use histogram graph
Matrix # 1
Change Matrix (Columns for Rows)
Rank Columns Base year left to right, large to small Process of ranking through sort command
Sort in Excel Select desired area with mouse Go to >Data > Sort Select base year row Click on descending option Select options
Sort in Excel In options select Sort left to right option
Creating the Graph Select are of data with mouse Go to >Windows >Chart and select:
Creating the Graph Make sure to select: Series in Columns Put label on the bottom
Type Inequality into Google to find us on the Web

More Related Content

T Stat Pres

  • 1. Measuring Inequality A practical workshop On theory and technique San Jose, Costa Rica August 4 -5, 2004
  • 2. Panel Session on: How to create a Stack-Bar Graph in Excel
  • 3. By James K. Galbraith and Enrique Garcilazo The University of Texas Inequality Project Session 6 http://utip.gov.utexas.edu
  • 4. Outline Obtain the individual between Theil components Create a Matrix Sectors in rows Years in columns Change to a new matrix with transpose command under paste special options we obtain: Sectors in columns Years in rows Sort sectors (with sort command) left to right from larger to smaller in base year (last year) Use histogram graph
  • 7. Rank Columns Base year left to right, large to small Process of ranking through sort command
  • 8. Sort in Excel Select desired area with mouse Go to >Data > Sort Select base year row Click on descending option Select options
  • 9. Sort in Excel In options select Sort left to right option
  • 10. Creating the Graph Select are of data with mouse Go to >Windows >Chart and select:
  • 11. Creating the Graph Make sure to select: Series in Columns Put label on the bottom
  • 12. Type Inequality into Google to find us on the Web