HELP WITH EXCEL

profileabd123123

NEED 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
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    line_graphs.docx