Sociology employment data
The employment data as shown below come from 2000 and 2010 censuses. You are asked to use the data to answer the following questions.
1. Replicate the data into an Excel spreadsheet. Now compute percentage for each of the employment brackets by year and residential area in San Antonio (note that the total should be used as your denominator). Attach a copy of the created excel spreadsheet.
2. Use the percentages you computed in 1 to create a bar chart for the four employment groups of the East Side, West Side, South Side, and Leon Valley, respectively, by year 2000 and 2010 (separate charts are acceptable but difficult to use for the questions shown below). In addition, label each bar to identify the residential area, year, employment category and the percentile value for that specific bar.
3. Use the percentages and bar charts you created in 1 and 2, identify and report which residential area, using all four employment brackets, has the most employed respondents, by percentage, in San Antonio in 2000 and 2010, respectively (one sentence).
Place this order with us and get 18% discount now! to earn your discount enter this code: summer17 If you need assistance chat with us now by clicking the live chat button.