Question

The data shown provides some demographic and opinion data on whether the economy is moving in the right direction.

As you work, do not move the data from the original location. Otherwise, the cell references in your formulas will be different from mine so when you are asked for Excel formulas on the Blackboard quiz, your answer could be maked wrong.

(a) On the right, give the distribution of the political party affiliation in terms of frequency and % frequency.

(b) In this sample, which party affiliation occurred most frequently? Which was the least frequent?

(c) What % of the respondents have pessimistic perception on the economy (No on Economy Perception)?

(d) Filter the data to show only the respondents who are home owners (Yes on Home Owner) and are optimistic (Yes on Economy Perception). How many such respondents are there?

(e) Optional - Extra credit: Answer (d) by using =COUNTIFS function. Use the criteria "Yes" for both conditions. In Blackboard submission, you will be asked to copy and paste the function you used here.

c	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

Answer 1

a) The distribution of Political party affiliation in terms of frequency and Percentage frequency is as follows.

Political Party	Count of Political Party(Frequency)	Percentage
Democrat	12	24 %
Independent	22	44 %
Republican	16	32 %
Grand Total	50

b) The ''Independent" political party affiliation ocurred most frequently at 44% (22 times) and "Democrat" political party affiliation ocurred least frequently at 24% (12 times).

c) The frequency of respondents on Economy perception is as follows.

Economy Perception	Count of Economy Perception (Frequency)	Percentage
No	38	76 %
Yes	12	24 %
Grand Total	50

The percentage of respondents having pessimistic (No response) percentage of the economy is 76%.

d) Following are the respondent who are Home Owners (Yes response) and have an optimistic perception of the Economy (Yes response)

c	Age	Gender	Years College	Political Party	Home Owner	Voted in Last Election	Economy Perception
1	32	Male	2	Democrat	Yes	Yes	Yes
30	30	Male	4	Republican	Yes	Yes	Yes
33	37	Male	2	Democrat	Yes	Yes	Yes
37	27	Female	0	Independent	Yes	Yes	Yes
38	28	Female	2	Democrat	Yes	Yes	Yes
43	35	Female	7	Democrat	Yes	Yes	Yes
44	25	Female	4	Independent	Yes	Yes	Yes
50	66	Male	2	Republican	Yes	Yes	Yes

The number of respondents satisfying the above criteria ar 8.

e) By using the excel function COUNTIFS, the above filter conditions can be applied.

Following is the excel function.  

=COUNTIFS(F1:F51,"=Yes",H1:H51, "=Yes")

In tha above formula, F1:F51 range contains the Home Owner data and H1:H51 range contains Economy Perception data.

The output of the excel function is 8 which is the same as the answer to Question d.