In: Statistics and Probability
Finally, the researcher considers using regression analysis to establish a linear relationship between the two variables – hours worked per week and income earned per year.
c) Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.
| Yearly Income ('000's) | Hours Per Week | 
| 43.8 | 18 | 
| 44.5 | 13 | 
| 44.8 | 18 | 
| 46.0 | 25.5 | 
| 41.4 | 11.6 | 
| 43.3 | 18 | 
| 43.6 | 16 | 
| 46.2 | 27 | 
| 46.8 | 27.5 | 
| 48.2 | 30.5 | 
| 49.3 | 24.5 | 
| 53.8 | 32.5 | 
| 53.9 | 25 | 
| 54.2 | 23.5 | 
| 50.5 | 30.5 | 
| 51.2 | 27.5 | 
| 51.5 | 28 | 
| 52.6 | 26 | 
| 52.8 | 25.5 | 
| 52.9 | 26.5 | 
| 49.5 | 33 | 
| 49.8 | 15 | 
| 50.3 | 27.5 | 
| 54.3 | 36 | 
| 55.1 | 27 | 
| 55.3 | 34.5 | 
| 61.7 | 39 | 
| 62.3 | 37 | 
| 63.4 | 31.5 | 
| 63.7 | 37 | 
| 55.5 | 24.5 | 
| 55.6 | 28 | 
| 55.7 | 19 | 
| 58.2 | 38.5 | 
| 58.3 | 37.5 | 
| 58.4 | 18.5 | 
| 59.2 | 32 | 
| 59.3 | 35 | 
| 59.4 | 36 | 
| 60.5 | 39 | 
| 56.7 | 24.5 | 
| 57.8 | 26 | 
| 63.8 | 38 | 
| 64.2 | 44.2 | 
| 55.8 | 34.5 | 
| 56.2 | 34.5 | 
| 64.3 | 40 | 
| 64.5 | 41.5 | 
| 64.7 | 34.5 | 
| 66.1 | 42.3 | 
| 72.3 | 34.5 | 
| 73.2 | 28 | 
| 74.2 | 38 | 
| 68.5 | 31.5 | 
| 69.7 | 36 | 
| 71.2 | 37.5 | 
| 66.3 | 22 | 
| 66.5 | 33.5 | 
| 66.7 | 37 | 
| 74.6 | 43.5 | 
| 62.0 | 20 | 
| 57.3 | 35 | 
| 55.3 | 24 | 

_________________________________________________________
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.6715 | |||||
| R Square | 0.4509 | |||||
| Adjusted R Square | 0.4419 | |||||
| Standard Error | 6.2518 | |||||
| Observations | 63 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 1957.439918 | 1957.44 | 50.0822 | 1.7094E-09 | |
| Residual | 61 | 2384.157225 | 39.0845 | |||
| Total | 62 | 4341.597143 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 36.157 | 3.087 | 11.712 | 0.000 | 29.984 | 42.330 | 
Hours
Per Week( ) | 
0.708 | 0.100 | 7.077 | 0.000 | 0.508 | 0.908 | 
_______________________________________

Where y(hat) is yearly income, x is hours per week
Interpretation - By increasing one unit in hours per week there is on an average $ 0.708 increase in yearly income