The reasons given by workers for quitting their jobs generally fall into one of two categories:

(1) Worker quits to seek or take a different job, or (2) worker quits to withdraw from the labor force. Economic theory suggests that wages and quit rates are related. The table below lists quit rates (quits per 100 employees) and the average hourly wage in a sample of 15 manufacturing industries.

Industry Quit Rate,y Average Wage, x($)

1 1.225 8.7

2 0.525 10.85

3 2.425 6.68

4 3.225 5.87

5 1.525 10.44

6 1.525 9.61

7 0.825 11.09

8 0.325 13.79

9 1.825 8.49

10 3.625 6.04

11 2.125 8

12 1.725 6.93

13 1.225 9.33

14 1.625 11.43

15 1.825 9.3

Use Excel to find the regression equation and the coefficient of determination:

a)Do the data present sufficient evidence to conclude that the average hourly wage contributes useful information for the prediction of quit rates? What does your model suggest about the relationship between quit rates and wages?

b)Predict the Quit rate for an average wage of $7.50.

c)Make a scatterplot to represent the data.Comment on the relationship between Quit Rate, y and Average Wage, x.

d)Using excel, find the correlation coefficient r, and coefficient of determination and interpret each.

e)Construct a 95% confidence interval for the population mean quit rate for the industries. Interpret your result.

f)