Gini coefficients census data

Gini coefficients census data - aMethod used for...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
aMethod 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 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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. library(ineq)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

Gini coefficients census data - aMethod used for...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online