Problem #1:Simple Correlation Analysis

Here is data on the number of crimes (x variable) and the number of arrests (y variable) for a sample of five cities:

City Crimes (in millions) Arrests (in millions)

Gilliganville 1.6 .78

Gidget City 1.55 .80

Bahama Oaks 1.44 .73

Mendelville 1.40 .72

Billy Oaks 1.32 .68

Maddie Pines 1.23 .64

Katieville 1.22 .63

Create data table (Include each city, each raw score, mean for X and Y, Sample Standard Deviation for X and Y, Z score for X, Z score for Y, and your sum of cross products (Zx x Zy). Please show your calculations.

Calculate r and r^2. Please show your calculations.

Conduct your hypothesis test at the 95% level of significance.Include all required steps.Remember to use your critical value (Appendix I).

Problem #2: Regression Analysis

Using the data from Problem #1, predict the number of arrests for a city with 1.50 million crimes per year. Please show your calculations.

Y' = a+bX

b = r(^sY/^sX)

__ __

a = Y - bX