Case Problem: A Bipartisan Agenda for Change

***MUST BE DONE IN EXCEL ONLY**

The purpose of this assignment is to apply test of independence to a case.

1. Open the dataset of NYREFORM (attached) and read the case entitled A Bipartisan Agenda for Change in its entirety at the end of Chapter 12.
2. Use descriptive statistics to summarize the data and make your preliminary conclusions about the independence of the response and party affiliation for each of the three questions in the survey.
3. With regard to survey question 1, test for the independence of the response and party affiliation. Use = .05
4. With regard to survey question 2, test for the independence of the response and party affiliation. Use = .05
5. With regard to survey question 3, test for the independence of the response and party affiliation. Use = .05
6. Does it appear that there is broad support for change across all political lines? Explain.