The state of Happyland has nine congressional districts. In the file named Problem23data.xlsx, you are given a

Question:

The state of Happyland has nine congressional districts. In the file named Problem23data.xlsx, you are given a voter’s district and whether the voter is a Democrat or Republican. Construct a PivotTable and PivotChart that show the percentage of Democrats and Republicans in each district. Assuming that the party with the most voters in a district wins the election, how many districts will each party win? Note: this problem illustrates why the Republicans usually control the House of Representatives, even though the Democrats usually receive more total votes nationwide.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: