(Solved): Governor Political Affiliation and Total State Expenditure per capita: - Using a PivotTable: Prepar ...

Governor Political Affiliation and Total State Expenditure per capita: - Using a PivotTable: Prepare a cross tabulation of governor political affiliation (rows) and total state expenditure per capita (columns). Group Settings: min= 3970, $$\max =16896$$, by $$=3500$$. No need to copy and paste the table to the homework. But you need it for the next step. - Prepare a 100\% Stacked Bar Chart of Governor Political Affiliation (horizontal axis category) and Total State Expenditure per capita (stacked categories). Copy and Paste it here. - Which political party spends the most? 10. An interesting question is whether governments in states that have higher median household income spent more. - Do a Scatter Plot of Median Annual Household Income (horizontal axis) and Total State Expenditure per capita. Add a linear trend line. Copy and Paste it here. - What is the correlation coefficient of these variables? Is the relation strong or weak? Do you think states with low Median Annual Household Income should spent more money relative to states that have higher Median Annual Household Income? Explain.