1. A police researcher is concerned that officers may not be assigned to areas where they are needed. He hopes to investigate whether there is a connection between the number of police officers assigned to a particular block and the number of violent incidents reported on that block during the previous week. Use the data below to test whether or not the number of officers assigned to a block and the number violent incidents that occurred on that block are correlated. Use alpha=.05.

2. Gottfredson et al. (2003) randomly assigned drug offenders to a drug treatment court in Baltimore (MD) or to a regular court. Their hypothesis was that providing drug treatment to these drug offenders is an integral part of their rehabilitation. Offenders who went to drug treatment court, they hypothesized, would be less likely to recidivate in the future. 139 offenders were randomly assigned to the experimental group and 96 offenders were randomly assigned to the control group. In their outcome evaluation, they wanted to examine whether the drug treatment court significantly reduced drug-related recidivism. They found that 40.6% of the experimental group and 54.2% of the control group were re-arrested with at least one new drug charge. Perform hypothesis tests to determine if the drug treatment court significantly reduced drug-related recidivism. Use a 0.05 level of statistical significance.

EXCEL IS ONLY TO BE USED AS A WAY TO ORGANIZE THE WORK AND/OR AS A CALCULATOR. BEYOND THE 'SUM' FUNCTION WE MAY NOT USE THE FUNCTIONS WITHIN EXCEL TO COMPLETE THE ASSIGNMENT.