Skip to content

AntwanW/Election_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ELection_Analysis

Overview of Election Audit

This election analysis's purpose was to complete an election audit of a congressional election and determine 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.

Election Audit Results

  • The total amount of votes that were cased in the election was 369,711.

    • Denver received the largest number of votes.
    • Denver won 82.8% (38,855)of the total votes.
    • Jefferson won 10.5% (306,055)of the total votes.
    • Arapahoe won 6.7% (24,801)of the total votes.
  • The Candidates

    • First place is Diana DeGette received the most votes at 73.8% of 272,892 votes.
    • Second place is Charles Casper Stockham received 23% of 85,213 votes.
    • Third place is Raymon Anthony Doane received 3.1% of 11,606 votes.

This is an image

Election Audit Summary

This election script can be used to test the popularity of a particular candidate by analyzing the percentage of voters in a specific county. It could then reveal which candidate was most popular in that area. This script can be modified to be used for any election, such as favorite ice cream or population growth. If the data includes other characteristics such as age or gender, the results can be broken down even further.

About

In this analysis, I used ERDs and Schemas to design databases and write intermediate-level SQL queries to answer critical business questions for the company's HR department. The result is a well-structured database with implemented constraints and foreign and primary keys.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages