Please answer A.-F.

Full questions and data are given, including full data on chart.

E F G H J K M N O B C D Economic Poll The data shown provides some demographic and opinion data on whether the economy is moving in the right direction. Frequency % Frequency a) On the right, give the distribution of the political party affiliation in terms of frequency and % a) Democrat frequency. (b) In this sample, which party affiliation occurred most frequently? Which was the least frequent? Republican (c) What % of the respondents have pessimistic perception on the economy (No on Economy Independent Perception)? (d) Filter the data to show only the respondents who are home owners (Yes on Home Owner) and b) 10 are optimistic (Yes on Economy Perception). How many such respondents are there? 11 (e) Answer (d) by using =COUNTIFS function. Use the criteria "Yes" for both conditions C) 12 Reference video: https://youtu.be/6V75h4htM_o 13 (f) Build a frequency distribution of Age. Use the limits given to the right of the data. d) 14 (g) Create a histogram for the frequency distribution of Age. 15 e) 16 17 18 19 Voted in Last Economy Respondent Age Gender Years College Political Party Home Owner Election Perception f) Lower Limit Upper Limit Frequency % Frequency 32 Male Democrat Yes Yes Yes Response to: Is the economy 10 19 35 Female Republican No Yes No moving in the right direction? 20 29 No 39 29 Female Independent No No 30 31 Female Republican No Yes No 40 49 Male Republican No Yes No 50 59 32 Female Republican Yes Yes No 60 69 66 64 Male Republican Yes Yes No Male Male Female Male Female Male Male HOANOOAOO - NWAAUIOANN Democrat No Yes Yes Republican No Yes No Independent No Yes No Independent No No No Republican No Yes No Democrat No Yes Yes Independent No No No Female Republican Yes Yes No Female Republican No Yes No Male Democrat No Yes Yes Female Democrat No Yes No 20 Male Independent No No NoEconomy Political Party Home Owner Voted in Last Election Perception Yes Respondent Years College Yes Response to: Is the economy 20 Age Gender Democrat Yes Yes No moving in the right direction? Male No No Female Republican No No Female Independent Republican No Yes No Female Yes No Republican No Yes No Male Republican Yes Yes No Female Male Republican Yes No Yes Yes No Male Democrat Yes Male Republican No Yes No Female Independent No No No No Independent Yes No Male No Female Republican Democrat No Yes Yes Male No Independent No No Male Yes Yes No No Female Republican Yes Yes Female Republican No Male Democrat No Yes No Yes No Democrat No No Female No Male Independent Yes Democrat No Yes Female No Yes No Independent Yes No Male No Independent No Female Female Independent No Yes No No No Male Independent No Yes No Mal Independent No Yes No NODOANANUN AUNOONNNAOA- A A NOWANNN- OANDODOO- NWAAMOANN No Male Republican Republican No Yes No No Male Independent Yes Yes Yes No Female Republican Yes Yes Female Yes No Male Republican No No Female Democrat No No Female Independent No Yes Yes Yes Male Democrat No No No No Male Democrat No Yes Male Republican Yes Yes No Yes Female Independent Yes Independent Yes Yes Female Democrat Yes Yes Yes No Female Yes Female Independent Yes No Male Independent Yes No Independent Yes Yes Female Yes No Male Republican Yes Yes Democrat Yes Yes Yes Yes Female Independent Yes No Female Yes Yes Male Independent Yes No No Female Independent No Independent No No Female Yes Yes No No Female Independent Yes Yes Yes Female Democrat Yes Yes Male Republican