Distribution of Income

hknfla

Main

Home >Homework Answsers >Business & Finance homework help >Economics homework help

worksheet EXCEL

I need help with completing my Excel worksheet for Microeconomics.

3 years ago
30.11.2023
20

Report issue

files (2)

Unit7-Chapter15-ScenarioAssignmentExcelWorksheet-DistributionofIncome.xlsx
Unit7-Chapter15-ScenarioAssignment-DistributionofIncome.ppsx

Unit7-Chapter15-ScenarioAssignmentExcelWorksheet-DistributionofIncome.xlsx

Sheet1

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

Unit7-Chapter15-ScenarioAssignment-DistributionofIncome.ppsx

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

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

Unit7-Chapter15-ScenarioAssignment-DistributionofIncome.ppsx

Distribution of Income

Income Inequality, Income Mobility, and Economic Discrimination

The Opportunity Atlas

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


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

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

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

Unit7-Chapter15-ScenarioAssignmentExcelWorksheet-DistributionofIncome.xlsx

Sheet1

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

Unit7-Chapter15-ScenarioAssignment-DistributionofIncome.ppsx

Distribution of Income

Income Inequality, Income Mobility, and Economic Discrimination

The Opportunity Atlas

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


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

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

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

Unit7-Chapter15-ScenarioAssignmentExcelWorksheet-DistributionofIncome.xlsx

Sheet1

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

Unit7-Chapter15-ScenarioAssignment-DistributionofIncome.ppsx

Distribution of Income

Income Inequality, Income Mobility, and Economic Discrimination

The Opportunity Atlas

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


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

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