Question: Question One Use the data Excel Data for Class & Problem Sets that we have been using throughout the semester. Use these data to examine

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!