demographic profile of a foreign-born population in the United States. You will be given data on a foreign-born population and then prepare a narrative description of this population in comparison to the native-born population.
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. The country i selected is australia 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.
I am attaching the australia. File. Please use this only and follow the instructions.
