I need help in answering these 5 questions; 1. open the file Income Data for Assignment). This will get you into Excel. Now compute percentage for each of the income 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 income 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). Additionally your are to label each bar as to which region, the associated, year, income category and the value for that specific bar. 3. Use the percentages and bar charts you created in 1 and 2, identify and report which area, using all four income brackets, appears to be most affluent in San Antonio in 2000 and 2010, respectively (one sentence). 4. First, use 1 and 2 to determine which income group has the largest increase or decrease between 2000 and 2010 for each of the four residential areas. Then, use one sentence to summarize income changes overtime across the four residential areas within the identified income group. 5. Write a small paragraph (less than 10 sentences) to discuss if there is an income (in) equality in San Antonio and whether or not this income (in)equality has changed overtime. Be sure to use numerical values to support your arguments. Note : Open the excel file that I have attached, and the QLP assignment introduction to sociology to put the answer under each question.

I need help in answering these 5 questions; 1. open the file Income Data for Assignment). This will get you into Excel. Now compute percentage for each of the income 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 income 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). Additionally your are to label each bar as to which region, the associated, year, income category and the value for that specific bar. 3. Use the percentages and bar charts you created in 1 and 2, identify and report which area, using all four income brackets, appears to be most affluent in San Antonio in 2000 and 2010, respectively (one sentence). 4. First, use 1 and 2 to determine which income group has the largest increase or decrease between 2000 and 2010 for each of the four residential areas. Then, use one sentence to summarize income changes overtime across the four residential areas within the identified income group. 5. Write a small paragraph (less than 10 sentences) to discuss if there is an income (in) equality in San Antonio and whether or not this income (in)equality has changed overtime. Be sure to use numerical values to support your arguments. Note : Open the excel file that I have attached, and the QLP assignment introduction to sociology to put the answer under each question.