(a) In Economic Poll of Problem A in Ch. 2 homework, recall you obtained frequency and % frequency distributions for the Political Party.Do this again, this time with PivotTable.It should have format like this:

Political PartyFrequency% Frequency

Democrat

Republican

Independent

We will figure out which party is most pessimistic about the economy (Economy Perception = No) by creating PivotTables.

(b) First, create a crosstab PivotTable with row labels = Political Party and column labels = Economy Perception.For Values, use any categorical variable.This should give you count for each Party/Perception combination.

Your Pivot table should be formatted like this:

Economy Perception

Political PartyNoYes

Democrat

Independent

Republican

(c) Now make a copy of this PivotTable and format the values as % of Row Total.

This should give you conditional probabilities like P(Economic Perception = No | Democrat), P(Economic Perception = Yes | Democrat), etc.Finally, answer the question:which group is the most pessimistic?Which values did you compare to answer this?