In: Statistics and Probability
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and 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 interpret the scatterplot?
Run a regression analysis using Data Analysis/Regression Tool and use the output to answer the following questions:
d. What is the correlation between distance to work and days absent? What does it say about the strength of the relationship?
e. What is the coefficient of determination? How would you interpret 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 you interpret the p-value?
h. What is the regression formula resulting from this analysis between Distance to Work and Days Absent?
i. Use your formula to predict the number of days absent for an employee who lives 9 miles from work.
j. Use your formula to predict the number of days absent for an employee who lives 17 miles from work.