A Colorado Board of Elections employee wants us to analyze the election audit of a recent local congressional election. The information we are looking for are the voter turnout for each county, the percentage of votes from each county out of the total count, and the county with the highest turnout.
- This congressional election had 369,711 votes casted.
- The number of votes and their percentages in each county are presented as the following:
- Jefferson: 10.5% (38,855)
- Denver: 82.8% (306,055)
- Arapahoe: 6.7% (24,801)
- Denver had the largest number of votes.
- The number of votes and their percentages each candidate received are presented as the following:
- Charles Casper Stockham: 23:0% (85,213)
- Diana DeGette: 73.8% (272,892)
- Raymon Anthony Doane: 3.1% (11,606)
- The winner of the election was Diana DeGette with a vote count of 272,892 (73.8% of the total votes).
This script should save the election commission time for future elections. The code should run showing the same data we have as the first image posted in this readme given that the excel file provided remains in the same format with column A (ballot ID), column B (county), and column C (candidate). All we need to do is replace the columns with the current election data and run the code.
The script could be improved by showing how many and what percentage of votes from each specific county went to each of the candidates. This shows where each county's priorities lie from which candidate they prefer. Adding onto this idea and the script, we could also display which county preferred which candidate.