{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Gini coefficients census data-1

# Gini coefficients census data-1 - Method used for...

This preview shows pages 1–2. Sign up to view the full content.

Method used for calculating Gini Coefficients for Census 2000 data by Mark L. Burkey Here is enough information so that you can learn to computer Gini coefficients and understand how these were calculated. These Ginis are from Household Income . All suggestions and corrections are welcome! I am using a Windows-based computer and Microsoft Excel. To compute gini coefficients with Census 2000 data: Get variables P52 and P54. Get rid of total households, and total income, and total income for households less than 200,000 1) Transpose data with midpoints of classes in left hand column, labeled “x” 2) end up with 16 midpoints like so (but in a column) 5000 12500 17500 22500 27500 32500 37500 42500 47500 55000 67500 87500 112500 137500 175000 The highest midpoint is unknown since it is for all households earning above \$200,000. Leave it blank(the category after 175000). Append row of total incomes for hholds making above 200000 as row 18 in Excel, which will become obs#17 when it is read into R 3) Put the frequencies of households in counties, etc. in different groups, and label the columns y1, y2,… 4) Read the data into R. From Excel the easiest way is to copy all of the data to the Clipboard (highlight, Ctrl-C). Then in R, type dataone=read.delim(“clipboard”) attach(dataone) 5) Now, you are ready to compute gini coefficients.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}