Question One

Use the data Excel Data for Class & Problem Sets that we have been using throughout the semester. Use these data to examine if people who are employed (Q8) are more frequently the victims of theft (Q30) than people who are not employed. Test your null hypothesis at a .05 using Excel (hint: this is a chi-square question). You must create a pivot table first. You must upload an Excel Workbook that has a tab called "Chi Square" that shows your pivot table and the table you make to calculate chi-square as well as the excel formula for the hypothesis test.

A. How many students are employed?

B. What percentage of students have been the victims of theft?

C. What's the null and research hypothesis in words and symbols.

D. What is df for this problem?

E. What can you conclude about the relationship between employment and theft?