1 / 12

Measuring Inequality

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.

gasha
Download Presentation

Measuring Inequality

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Graphin 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

  5. Matrix # 1

  6. Change Matrix (Columns for Rows)

  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

More Related