The data shown provides some demographic and opinion data on whether the economy
ID: 2947831 • Letter: T
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 YesExplanation / Answer
a) The distribution of Political party affiliation in terms of frequency and Percentage frequency is as follows.
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.
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)
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.
Political Party Count of Political Party(Frequency) Percentage Democrat 12 24 % Independent 22 44 % Republican 16 32 % Grand Total 50Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.