Finally, I made one last sheet to aggregate and compare all of the data! The result: Average Partisanship Ratios for each party and each year, with a bar graph showing the results. - For each year, I
**averaged the partisanship ratios**from each party, making sure to skip "common-sense" votes in my range. - I made a
**bar graph**with this full data set though "Insert=>Charts=>Bar."
A screenshot of this final analysis is below. (Note-- for now, ignore "Agree Ratio" and its corresponding chart. These will be addressed in the next section.)To keep moving through data analysis, go to Part 2 Overview (Agreement Ratio). To see the results and analysis of this Partisanship Ratio data, go to Result: Partisanship. |