A sociologist was hired by a large city hospital to investigatethe relationship between the number of unauthorized days thatemployees are absent per year and the distance (miles) between homeand work for the employees. A sample of 10 employees was chosen,and the following data were collected.

Distance to Work	Days Absent
1	8
3	5
4	8
6	7
8	6
10	3
24	5
14	2
14	4
18	2

a. Which is the independent/explanatory variable?

b. Which is the dependent/response variable?

Enter the data into an Excel spreadsheet.

c. Create a scatterplot for these data. How would you interpretthe scatterplot?

Run a regression analysis using Data Analysis/RegressionTool and use the output to answer the following questions:

d. What is the correlation between distance to work and daysabsent? What does it say about the strength of therelationship?

e. What is the coefficient of determination? How would youinterpret it?

f. Write the hypotheses for the test of the slope.

g. What is the p-value for the test of the slope? How would youinterpret the p-value?

h. What is the regression formula resulting from this analysisbetween Distance to Work and Days Absent?

i. Use your formula to predict the number of days absent for anemployee who lives 9 miles from work.

j. Use your formula to predict the number of days absent for anemployee who lives 17 miles from work.