econ 339 demographic profile project need stata software to do and excel 2

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.

Order a Similar Paper Order a Different Paper


In this profile, you will report on three populations in the United States: the native born, a 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 to download a Stata data file of the American Community Survey, a Stata do file that has the commands to generate and tabulate the estimates necessary to produce the profile.The data file is large and takes about 20 minutes to download from blackboard.Place the do file and the data file in a folder on a computer in the economics computer lab next to the economics office.Click on the do file.After you open the do file, you will need to click the last icon on the toolbar, execute (do) to run the commands below. If you want to change the foreign-born population, reference the note in the do file and change the place of birth (found in the data dictionary) to the foreign-born population that you want to estimate.

Once you have your estimates, you need to transfer them into excel and create column graphs for the following characteristics:

  • Total population either as absolute numbers or as percentages of the total population
  • Median age
  • Citizenship status as percentages of each population (the native born will be 100% citizens)
  • Marital status as percentages of each population (married)
  • 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)
  • Labor force participation rate as percentages of each population age 16 and older
  • Unemployment rate as percentages of each population age 16 and older
  • Occupation distribution as percentages of each population that is employed
  • Median income of full-time workers for each of the three populations
  • Health insurance status of each of the three populations

(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

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 finding to something that we have studied in the course.

The profile is to be submitted in class on the last day of class. Only a hard copy submitted that day will be graded.

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.

Order a Similar Paper Order a Different Paper