Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Demographic Profile Description

In this profile, you will report on three populations in the United States: the native born, the foreign-born population of your choosing, and the foreign-born population, excluding the foreign-born population you chose.

In class, you will receive a demonstration on how the software program Stata used a data file of the American Community Survey to produce the estimates to complete this profile assignment.  By Friday of this week, you need to email me the country for which you want to do this profile on. Once you have your estimates, you need to transfer them into excel and create column graphs for the following characteristics:

1. Total population either as absolute numbers or as percentages of the total population

2. Median age

3. Citizenship status as percentages of each population (the native born will be 100% citizens)

4. Marital status as percentages of each population (married)

5. Educational attainment as percentages of each population age 25 and older (less than high school, high school, some college, and bachelor’s degree or higher)

6. Labor force participation rate as percentages of each population age 16 and older

7. Unemployment rate as percentages of each population age 16 and older

8. Occupation distribution as percentages of each population that is employed

(use these categories Management; Professional; Service, Sales, and Office; Farming Fishing Forestry; Construction, Extraction, Maintenance, and Repair; and  Production, Transportation, and Material Moving) exclude military and unemployed 5 years or never worked

9. Median income of full-time workers for each of the three populations

10. Health insurance status of each of the three populations

Create a graph for each of these 10 characteristics and place it in a word document.  Title the graph and then write a descriptive paragraph of what you find as estimates and relate these findings to something that we have studied in the course. You then need to add an introductory and concluding paragraph to complete this assignment.