HELP WITH EXCEL
abd123123NEED TO CREATE TWO LINE GRAPHS USING DATA ON EXCEL-DUE TODAY AT 10 AM
You will need to download the Excel spreadsheet files (XLS or CSV) for Table A-1 and Table A-2.
Contained in Table A-1 are rates of self-reported voter turnout in elections from 1964 to 2014 by age. You will analyze the percent of the total population that voted for age groups 18-24, 25-44, 45-64, and 65 years and over.
Contained in Table A-2 are rates of self-reported voter turnout in elections from 1964 to 2014 by educational attainment. You will analyze the percent of the total population that voted for educational attainment levels less than 9th grade, 9th to 12th grade, no diploma, high school graduate or GED, some college or associate’s degree, and bachelor’s degree or more.
You should cut and paste each of these columns into a new spreadsheet for the elections from 1964 to 2014. Once this is done, sort the data by ascending year. Finally, you should only keep presidential elections (1964, 1968, 1972, 1976, 1980, 1984, 1988, 1992, 1996, 2000, 2004, 2008, 2012).
Using a spreadsheet program, create two different line graphs showing how voter turnout rates have changed over time by age and level of educational attainment respectively. The x-axis should be the years from 1964 through 2012 (presidential elections only) and the y-axis should be percent that voted. In the respective line graph, a separate line should be drawn for the each category age (18-24, 25-44, 45-64, and 65 years and over) and educational attainment (less than 9th grade, 9th to 12th grade, no diploma, high school graduate or GED, some college or associate’s degree, and bachelor’s degree or more).
Cut and paste each of the line graphs into your homework document labeled 1a and 1b. For each line graph, describe in a few sentences the 48-year trend in voter turnout.
- 8 years ago
- 5
Purchase the answer to view it
- line_graphs.docx
- Psychology
- MKT/ 571 WEEK THREE QUIZ (2015) 100% CORRECT ANSWERS
- Developing a Public Relations Plan, Part 1
- Extreme
- Stats
- Retirement
- COM 310 Week 3 Individual Assignment Communication Theories Paper
- CMGT 554 Week 4 Individual Assignment Patton-Fuller Community Hospital Networking Project
- The Federal Reserve Board of Governors
- Thermodynamics