Download the “Voting Behavior” data and the brief data description from the book’s Web site. This is...

Question

Download the “Voting Behavior” data and the brief data description from the book’s Web site. This is a data set manually compiled from counties all around the United States. The data is partially processed, that is, some derived variables are created. Your task is to thoroughly preprocess the data by identifying the error and anomalies and proposing remedies and solutions. At the end you should have an analytics-ready version of this data. Once the preprocessing is completed, pull this data into Tableau (or into some other data visualization software tool) to extract useful visual information from it. To do so, conceptualize relevant questions and hypotheses (come up with at least three of them) and create proper visualizations that address those questions of “tests” of those hypotheses.

Banasree · Accepted Answer

From your book, end of chapter 2, exercises question 1.
“Voting Behavior” This is a data set manually compiled from counties all around the United States. The data is partially processed, that is, some derived variables are created. Your task is to thoroughly pre-process the data by identifying the error and anomalies and proposing remedies and solutions. At the end you should have an analytics-ready version of this data.
Once the pre-processing is completed, pull this data into Tableau to extract useful visual information from it. To do so, conceptualize relevant questions and hypotheses (come up with at least three of them) and create proper visualizations that address those questions of “tests” of those hypotheses.
Ans:
Scenario 1 - Group – State No and Country No
Scenario 2 - Group – PCI and Medium Family Income
Scenario – 3- Group – Poverty Level and Unemployment
Scenario – 4 - Group – No of older and No of Younger
Analyzing above data, groups like unemployment, poverty level, no of older, no of younger, state no, country no,

Download the “Voting Behavior” data and the brief data description from the book’s Web site. This is a data set manually compiled from counties all around the United States. The data is partially...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment