5. (6 points) State Politics by Region. Create a pivot table that shows us the cross-tabulation of two variables: region and political party of a state's governor. Put the Region variable in the rows and Governor in the columns. We want to know if the likelihood of finding a governor from a specific party differs by region. For example, are we more likely to find Republican governors in the Midwest than the West? Display the values in the table in the way you feel best allows us to see this, and copy this table into your document. Make a chart based on the information in your pivot table. Explain briefly why you chose to present the type of chart you selected. Discuss your results. What do we learn about the relationship between these categorical variables from your table/chart? GDP GIUWLE GDF GIUWLIT Unemployment FLL Fully PLE 1 State 2 Alabama State Label Region Governor 2020 Q2 2021 (Q1 to Q3) Dec 2021 Population (millions) Pct Biden Vaccinated Bachelors AL South R -31.4 2.4 3.1 4.91 36.6 50 27.8 3 Alaska AK West R -33.1 2.1 5.7 0.71 42.8 60 31.9 4 Arizona AZ West R -23.1 4.7 4.1 7.25 49.4 59 33 5 Arkansas AR South R -24.9 2.4 3.1 3.01 34.8 53 24.9 6 California CA West D -31.0 5.9 6.5 39.83 63.5 69 36.9 7 Colorado CO West D -29.9 5.8 4.8 5.79 55.4 68 44.2 8 Connecticut CT Northeast D -34.8 4.8 5.8 3.60 59.3 77 42.4 9 Delaware DE South D -24.2 5.9 5 0.99 58.7 66 34.7 10 Florida FL South R -29.5 7.8 5.8 21.42 47.9 65 33.7 11 Georgia GA South R -28.6 5.6 4.4 10.63 49.5 53 34.8 12 Hawaii HI West D -45.8 12.6 2.6 1.41 63.7 76 35.5 13 Idaho ID West R -26.9 0.7 5.7 1.78 33.1 52 30.9 14 Illinois IL Midwest D -31.4 2.2 2.4 12.62 57.5 66 37.6 15 Indiana IN Midwest R -34.3 2.3 5.3 6.74 41 53 28.9 16 lowa IA Midwest R -24.8 2.8 2.7 3.13 44.9 61 29.5 17 Kansas KS Midwest D -29.6 0.7 3.5 2.90 41.6 59 35.1 18 Kentucky KY South D -34.2 1.6 3.3 4.47 36.2 56 27.4 19 Louisiana LA South D -33.3 2.7 3.9 4.66 39.9 52 27.2 20 Maine ME Northeast D -27.8 3.1 4.8 1.35 53.1 78 33.5 21 Maryland MD South R -30.2 -1.0 4.7 6.04 65.4 73 43.1 22 Massachusetts MA Northeast R. -33.0 6.3 5 6.90 65.6 77 46.9 23 Michigan MI Midwest D -40.7 6.1 3.9 10.19 50.6 58 32.1 24 Minnesota MN Midwest D -28.9 5.9 5.6 5.70 52.4 67 37.9 25 Mississippi MS South R 33.1 1.6 3.1 2.97 41.1 50 24.5 26 Missouri MO Midwest R -28.3 2.1 4.5 6.09 41.4 55 31.9 27 Montana MT West R -22.1 2.6 3.3 1.06 40.5 55 34.6 28 Nebraska NE Midwest R -27.1 -1.9 2.5 1.89 39.4 62 33.3 29 Nevada NV West D -54.3 9.1 1.7 3.08 50.1 59 28 30 New Hampshire NH Northeast R -33.7 8.4 6.4 1.34 52.7 69 40.2 31 New Jersey NJ Northeast D -38.9 3.0 2.6 8.83 57.3 73 43.1 32 New Mexico NM West D -31.6 1.4 6.3 2.09 54.3 69 30.1 33 New York NY Northeast D -33,2 4.9 5.8 19.76 60.9 74 39.5 34 North Carolina NC South D -30.7 4.2 6.2 10.51 48.6 59 34.8 35 North Dakota ND Midwest R -28.7 1.3 3.7 0.77 31.8 54 31.8 36 Ohio OH Midwest R -33.2 2.0 3.1 11.71 45.2 57 30.6 37 Oklahoma OK South R -30.1 3.0 4.5 3.97 32.3 55 27 38 Oregon OR West D -30.9 3.6 2.3 4.201 56.5 68 36.3 39 Pennsylvania PA Northeast D -36.4 3.5 4.1 12.85 50 66 34 40 Rhode Island RI Northeast D 31.9 9.6 5.4 1.07 59,4 79 38 41 South Carolina SC South R -28.4 3.3 4.8 5.15 43.4 55 31.7 42 South Dakota SD Midwest R -26.0 0.1 3.5 0.89 35.6 59 28.4 26 Missouri MO Midwest R -28.3 2.1 4.5 6.09 41.4 55 31.9 27 Montana MT West R -22.1 2.6 3.3 1.06 40.5 55 34.6 28 Nebraska NE Midwest R -27.1 -1.9 2.5 1.89 39.4 62 33.3 29 Nevada NV West D -54.3 9.1 1.7 3.08 50.1 59 28 30 New Hampshire NH Northeast R 33.7 8.4 6.4 1.34 52.7 69 40.2 31 New Jersey NJ Northeast D -38.9 3.0 2.6 8.83 57.3 73 43.1. 32 New Mexico NM West D -31.6 1.4 6.3 2.09 54.3 69 30.1 33 New York NY Northeast D -33.2 4.9 5.8 19.76 60.9 74 39.5 34 North Carolina NC South D -30.7 4.2 6.2 10.51 48.6 59 34.8 35 North Dakota ND Midwest R -28.7 1.3 3.7 0.77 31.8 54 31.8 36 Ohio OH Midwest R -33.2 2.0 3.1 11.71 45.2 57 30.6 37 Oklahoma OK South R -30.1 3.0 4.5 3.97 32.3 55 27 38 Oregon OR West D -30.9 3.6 2.3 4.20 56.5 68 36.31 39 Pennsylvania PA Northeast D -36.4 3.5 4.1 12.85 50 66 34 40 Rhode Island RI Northeast D 31.9 9.6 5.4 1.07 59.4 79. 38 41 South Carolina SC South R -28.4 3.3 4.8 5.15 43.4. 42 South Dakota SD Midwest R -26.0 0.1 3.5 0.89 35.6 59 43 Tennessee TN South R -40.8 3.5 2.6 6.79 37.5 44 Texas TX South R -28.5 5.7 3.8 28.96 46.5 45 Utah UT West R -16.8 3.4 5 3.22 37.6 46 Vermont VT Northeast R -38.5 1.0 1.9 0.63 66.1 47 Virginia VA South D -26.1 3.2 2.5 8.49 54.1 48 Washington WA West D -23.6 6.4 3.2 7.58 58 49 Washington D.C. DC South D 21.9 5.1 4.5 0.69 92.1 50 West Virginia WV South R 30.8 2.5 3.7 1.80 29.7 51 Wisconsin WI Midwest D -28.9 1.5 2.8 5.79 49.41 52 Wyoming WY West R -32.7 3.3 3.3 0.58 26.6 333352222332 55 31.7 28.4 30.7 59 33.2 61 36.9 80 42.1 71 42 70 38.4 70 63.6 56 23.1 64 31.8 50 28.2