Complete this and show your work

Name_________________________________________________________________

In these problems, you will:

• Write and test hypotheses for chi-square

• Calculate chi-square by hand and in excel

• Calculate and interpret values from a cross-tab

• Test null hypothesis for chi-square

Please answer the following on this page or on additional paper if needed. You must show all of your work to receive full credit for your answers.

• For any math problem, your final answer must be enclosed in a box.

• For any excel problem, follow the directions and upload with problem set

• Your homework must be completed independently, or it is considered academic dishonesty

1. You are interested to see if the relative frequency of those who hung out with their friends after school during the past week who were abused is different from the relative frequency of those who did not hang out with their friends who were abused. Using the table below, answer the following questions:

1. 1. What percentage of those who hung out with their friends have been abused?

1. 1. How many people were in the sample?

1. 1. Demonstrate how degrees of freedom for the chi-square test were determined.

1. 1. Write in symbols a null and research hypothesis.

1. 1. Test your null hypothesis at the .05 level of significance.

1. 1. Can you reject your null hypothesis? How do you know? Be specific!

1. What would the degrees of freedom be if you had a 3x7 table?

1. 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 create to calculate chi-square as well as the excel formula to do your hypothesis test. Also, answer the questions below:

1. How many students are employed?

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

1. Write a null and research hypothesis in words and symbols.

1. What is df for this problem?

1. Using excel, can you reject your null hypothesis? How do you know?

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