(a) Number of Male and Female respondents. (5 Points) (b) Count of different political party category respondents. (5 Points) (c) For the above counts obtained (in (a) and (b)) compute the individual proportions of the above respondent categories. (5 Points) (d) Construct a cross tabulation of Gender and Political party, with Years in College as the Summing variable. (10 Points) (e) Construct a Pivot Chart to visually represent the tabulation obtained in (d). (5 Points) (f) Add slicers for Political Party and Gender. (5 Points) (g) Count of respondents who have spent more than 2 years in college and are homeowners. (10 Points) (h) Count of respondents who have voted in the past year and are democrat supporters. (10 Points) (i) Use any Visual analytics tool to obtain the relationship between the years in college and the political party that they support. (10 Points) (j) Using the outcome of (h), comment on your analysis /results. (5 Points)

Respondent	Age	Gender	Years College	Political Party	Home Owner	Voted in Last Election	Economy Perception
1	32	Male	2	Democrat	Yes	Yes	Yes
2	35	Female	2	Republican	No	Yes	No
3	29	Female	4	Independent	No	No	No
4	31	Female	0	Republican	No	Yes	No
5	32	Male	5	Republican	No	Yes	No
6	66	Female	4	Republican	Yes	Yes	No
7	64	Male	4	Republican	Yes	Yes	No
8	22	Male	3	Democrat	No	Yes	Yes
9	21	Male	2	Republican	No	Yes	No
10	33	Female	1	Independent	No	Yes	No
11	38	Male	0	Independent	No	No	No
12	31	Female	0	Republican	No	Yes	No
13	39	Male	4	Democrat	No	Yes	Yes
14	30	Male	0	Independent	No	No	No
15	52	Female	5	Republican	Yes	Yes	No
16	35	Female	2	Republican	No	Yes	No
17	29	Male	4	Democrat	No	Yes	Yes
18	29	Female	0	Democrat	No	Yes	No
19	20	Male	1	Independent	No	No	No
20	32	Female	2	Democrat	No	Yes	Yes
21	32	Male	2	Independent	No	Yes	No
22	31	Female	2	Independent	Yes	No	No
23	37	Female	4	Independent	No	Yes	No
24	29	Male	3	Independent	No	No	No
25	38	Male	0	Independent	No	Yes	No
26	21	Male	2	Republican	No	Yes	No
27	41	Male	4	Republican	No	Yes	No
28	26	Female	4	Independent	Yes	No	No
29	25	Female	1	Republican	Yes	Yes	No
30	30	Male	4	Republican	Yes	Yes	Yes
31	27	Female	0	Democrat	No	No	No
32	32	Female	4	Independent	No	No	No
33	37	Male	2	Democrat	Yes	Yes	Yes
34	33	Male	2	Democrat	No	No	No
35	27	Male	2	Republican	No	Yes	No
36	30	Female	6	Independent	Yes	Yes	No
37	27	Female	0	Independent	Yes	Yes	Yes
38	28	Female	2	Democrat	Yes	Yes	Yes
39	27	Female	5	Independent	Yes	Yes	No
40	64	Male	4	Independent	Yes	Yes	No
41	34	Female	7	Independent	Yes	Yes	No
42	30	Male	5	Republican	Yes	Yes	No
43	35	Female	7	Democrat	Yes	Yes	Yes
44	25	Female	4	Independent	Yes	Yes	Yes
45	33	Male	2	Independent	Yes	Yes	No
46	32	Female	4	Independent	Yes	No	No
47	29	Female	0	Independent	No	No	No
48	37	Female	6	Independent	Yes	Yes	No
49	33	Female	6	Democrat	Yes	Yes	No
50	66	Male	2	Republican	Yes	Yes	Yes