Homework SourseTell us a question you need Given the following table Curre
Tell us a question you need
. Given the following table:
Current Length of Employment (Years)
Number of Workdays Absent
6
3
8
5
11
6
5
6
2
7
3
7
2
10
Develop and state an estimate (predictor) equation for ? given X. You can calculate the a and b constants using any method, manual, Excel, Regression analysis, etc.
Based on the estimate equation in part a, what is the estimated number of workdays absent given a worker who has been employed for 4 years?
Determine the correlation coefficient.
Determine the coefficient of determination.
help with
| Current Length of Employment (Years) | Number of Workdays Absent |
| 6 | 3 |
| 8 | 5 |
| 11 | 6 |
| 5 | 6 |
| 2 | 7 |
| 3 | 7 |
| 2 | 10 |
Solution
(1) Number of Workdays Absent = 8.1335-0.3496*Current Length of Employment (Years)
where a=8.1335
b=0.3496
---------------------------------------------------------------------------------------------------------
(2)8.1335-0.3496*4=6.7351
---------------------------------------------------------------------------------------------------------
(3) correlation coefficient = -0.5481
---------------------------------------------------------------------------------------------------------
(4) coefficient of determination =0.3004
| Regression output | confidence interval | |||||
| variables | coefficients | std. error | t (df=5) | p-value | 95% lower | 95% upper |
| Intercept | 8.1335 | 1.4623 | 5.562 | .0026 | 4.3745 | 11.8925 |
| Current Length of Employment (Years) | -0.3496 | 0.2386 | -1.465 | .2027 | -0.9628 | 0.2637 |
