Tableau Project -URGENT

Closed Posted 2 years ago Paid on delivery
Closed Paid on delivery

Please send your presentation (e.g. Colab, Datastudio, Tableau) on your quantitative analysis of CA-18 congressional 2022 candidates head of time. This should have the pros/cons and opportunities of each candidate using the voting and census data. Here is a suggested process:

Step 1: Gather precinct-level voting data for Congressional District 18. There are three counties in district 18. However, use Santa Clara only for this mini-project.

Step 2: Gather block-level US Census data from the website for Santa Clara County. You can find the link here: [login to view URL]

From that link, you can get a table for the feature (e.g. age, gender) that you want that looks something like this (selecting as many geographies as you want): [login to view URL],060855003002,060855004002&tid=ACSDT5Y2019.B01001&hidePreview=true

Step 3: Join data from Step 1 and Step 2 for at least one city in district 18. Cross-reference the election day map: [login to view URL]

and the census data map: [login to view URL]

This is done by visually looking at the map between the voting precinct and the census CBP. They will not match up perfectly.

Example for Palo Alto:

Precinct # CBP

2046 5114 (1, 2, 3) and 5113.01 (1, 2)

2009 5109 (1, 2) and 5107 (1) and 5115 (2)

2025 5108.01 (1, 2, 3) and 5109 (3)

2098 5110 (1, 2, 3, 4, 5)

2057 5113.02 (1, 2, 3) and 5112 (1, 2, 3, 4)

2068 5046.01 and 5111 (1, 2)

2013 5108.02 (1, 2) and 5108.03 (1, 2)

2108 5106 (1, 2, 3)

2043 5111 (3, 4) and 5114 (4)

2014 5107 (3) and 5117.01 (1)

2002 5116.09 and 5115 (1)

2005 5117.05 (1)

2125 5094.01 (2)

2018 5093.02 and 5093.04 (1)

2006 5094.01 (1)

2001 5117.07

Step 4: Analyze Step 3 joined data for the 2020 Congressional Race between Anna Eshoo and Rishi Kumar. What trends do you see across different precincts? Graph out these trends.

Step 5: Create a model that predicts this trend and measure the error.

Excel Data Warehousing Data Processing SPSS Statistics Data Entry

Project ID: #30626194

About the project

14 proposals Remote project Active 2 years ago

14 freelancers are bidding on average $264 for this job

kelvinm094

Esteemed employer, I hold a Master's degree in statistics making me a suitable person for your project. I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in Data Proces More

$140 USD in 2 days
(167 Reviews)
6.8
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$250 USD in 7 days
(106 Reviews)
7.1
ashikmohann

hi i am a python ,R developer and machine learning engineer. i can do the project for you and get the code as per requirement in colab or design in tableau . feel free to contact me and we can discuss the details .

$200 USD in 2 days
(10 Reviews)
4.4
haris021

I have Bachelors in Electrical Engineering and holds Masters degree in Energy Systems Engineering with strong research background. I have been extensively working on Tableau,PowerBI, Python and R for data analytics for More

$250 USD in 5 days
(8 Reviews)
3.8
hillaryjustin73

Hello Dear Client, Am a Business Intelligence Analyst with 2 years of experience in Data Visualization, data migration, and statistical reporting. I specialize in R studio, Power BI, and Tableau. I have developed vari More

$100 USD in 4 days
(8 Reviews)
4.0
monicawriter99

Dear esteemed client! I can help to complete your "Tableau Project -URGENT " project as per your requirements. I am an MBA writer with 5 years of experience. I have all the skills needed for your project such as SPSS More

$150 USD in 3 days
(5 Reviews)
3.5
harisrajputt26

Hello, my name Haris Rajput.I am a dedicated and hard working person who belives in honesty and good working relation. Though I am new at this sector of job but I have certain qualities which makes me good at this. I a More

$112 USD in 7 days
(0 Reviews)
0.0
vijay706686

Hi sir My Self Vijay Adhikari I'm 5 years working data entry

$140 USD in 5 days
(0 Reviews)
0.0
wharfizwariff

I am very good freelancer. I can do the work and the work will done according to timeline. thank you for your trust

$1400 USD in 7 days
(0 Reviews)
0.0
nnazwa

I am very good freelancer. I can do the work and the work will done according to timeline. Thank you for your trust.

$140 USD in 7 days
(0 Reviews)
0.0