City | Neighborhood Characteristics | |||
Zip Code | Median Rent | |||
Median Income | Job Growth Rate from 2004 to 2013 | |||
Improved/Regressed | Median Hhold, Income 2012-16 | |||
Median Hhold, Income 1990 | ||||
Poverty Rate in 2012-16 | ||||
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
All | Black | All | ||
All | White | All | ||
All | Hispanic | All | ||
All | Asian | All | ||
All | Amer. Indian | All | ||
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
All | All | Female | ||
All | All | Male | ||
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
High | All | All | ||
Middle | All | All | ||
Low | All | All | ||
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
Narrative | ||||
Excel Worksheet for Distribution of Income Scenario Assignment
Distribution of Income
Income Inequality, Income Mobility, and Economic Discrimination
The Opportunity Atlas
Opportunity Atlas was created by Raj Chetty and Nathan Hendren from Harvard University and John Friedman from Brown University, which takes data from many different sources and compiles estimated children’s outcomes into adulthood based upon neighborhoods.
The data set represents 20 million people born between 1978 – 1983 (94% of the people are born within the dated range).
This assignment will allow you to analyze the economic opportunities and the chances of mobility in your own neighborhood.
You will collect data using Opportunity Atlas and create a narrative for your neighborhood.
Step One
Start by going to the website:
https://www.opportunityatlas.org
Step one: Enter your current zip code or a zip code you would like to research. (You can not use zip code 33024 Pembroke Pines, FL. It will be used for the example.)
You will be able to see the median income per household in the zip code.
Opportunity Atlas states, “Neighborhoods where kids went on to earn lower average incomes are displayed in red; places where kids grew up to earn more are in blue.”
In the upper right-hand corner check the following:
All for Parent Income
All for Child Race
All for Child Gender
Section 1
Section 1: What is the median income in your selected neighborhood? Have the average incomes improved or regressed?
Fill in the first sections in the Excel Worksheet provided for this assignment
Take a screen shot of the map and include it in your assignment document. Paste the map from columns G to L and rows 1 to 15.
City | |
Zip Code | |
Median Income | |
Improved/Regressed |
Neighborhood Characteristics | |
Median Rent | |
Job Growth Rate from 04 to 13 | |
Median Hhold, Income 2012-16 | |
Median Hhold, Income 1990 | |
Poverty Rate in 2012-16 |
Example for Section 1
Example of zip code 33024, which is the zip code of Broward College – South Campus, Tract 12011110100:
Median Income = $40,000
Incomes have slightly regressed in the zip code.
City | Pembroke Pines |
Zip Code | 33024 |
Median Income | $40,000 |
Improved/Regressed | Regressed (red) |
Neighborhood Characteristics | |
Median Rent | $1,800 |
Job Growth Rate from 04 to 13 | -0.40% |
Median Hhold, Income 2012-16 | $56,000 |
Median Hhold, Income 1990 | $72,000 |
Poverty Rate in 2012-16 | 9.60% |
Step 2
Step Two: Keep the Parent Income as All, keep the Child Gender as All, and Change the Child Race to fill out the following chart in Excel.
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
All | Black | All | ||
All | White | All | ||
All | Hispanic | All | ||
All | Asian | All | ||
All | Amer. Indian | All |
Example for Section 2
Excel chart completed for zip code 33024
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | $40,000 | Lower (red) |
All | Black | All | $31,000 | Higher (blue) |
All | White | All | $44,000 | Lower (red) |
All | Hispanic | All | $38,000 | Lower (yellow) |
All | Asian | All | $71,000 | Higher (blue) |
All | Amer. Indian | All | N/A | N/A |
Step 3
Step Three: Keep the Parent Income as All, keep the Child Race as All, and change the Child Gender to fill out the following chart in Excel.
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
All | All | Female | ||
All | All | Male |
Example for Section 3
Excel chart completed for zip code 33024
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | $40,000 | Lower (red) |
All | All | Female | $41,000 | Lower (red) |
All | All | Male | $38,000 | Lower (red) |
Step 4
Step Four: Keep the Child Race as All, keep the Child Gender as all, and change the Parent Income to fill out the following chart in Excel.
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | ||
High | All | All | ||
Middle | All | All | ||
Low | All | All |
Example for Section 4
Excel chart completed for zip code 33024
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
All | All | All | $40,000 | Lower |
High | All | All | $47,000 | Lower |
Middle | All | All | $39,000 | Lower |
Low | All | All | $32,000 | Lower |
Step 5
Step 5: You now know how to change the different settings of Parent Income, Child Race, and Child Gender to acquire different household income for the different groups. In step 5, you can change all three settings to acquire additional income information for you to draw conclusions and build a narrative. Fill out the following chart in Excel with your data.
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
Example for Section 5
Excel chart completed for zip code 33024.
This is an example of Parent Income, Child Race, and Child Gender. You do NOT have to use the same parameters. Pick parameters that will help you build a narrative around your neighborhood.
Parent Income | Child Race | Child Gender | Household Income | Lower or Higher Income |
High | Hispanic | Female | $44,000 | Lower |
Low | Black | Female | $34,000 | Higher |
Middle | White | Male | $40,000 | Lower |
High | Black | Male | $35,000 | Higher |
High | Asian | All | $80,000 | Higher |
Assignment Question
With all the acquired data, creative a narrative of your selected neighborhood that explains income distribution, opportunity, and/or economic discrimination. (E.g., Are incomes improving or regressing for all groups or just some? Is there a large difference in income for gender? Could gender discrimination exist in your neighborhood after analyzing the data? Is there a strong case for income mobility? Were children of low-income parents able to improve their income or were they trapped in a low income? Did race play a role in income mobility?)
Example of a story based upon data:
https://www.npr.org/2018/10/04/654085265/the-american-dream-one-block-can-make-all-the-difference
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more