Southern Textiles wishes to predict employee wages by using the employee’s experience X1 and the
tutor4helpyou
data_table_for_southern_textiles.xlsxData Table for Southern Textile
| Wages Y (Thousands of dollars) | Experience X1 (Months) | Education (College Degree = 1, No College Degree = 0) | SUMMARY OUTPUT | |||||||||
| 27.1 | 47.2 | 1 | ||||||||||
| 20.1 | 40.1 | 0 | Regression Statistics | |||||||||
| 25.1 | 37.1 | 1 | Multiple R | 0.975206567 | ||||||||
| 22.3 | 44.7 | 0 | R Square | 0.9510278483 | ||||||||
| 25.2 | 41.9 | 1 | Adjusted R Square | 0.9452664187 | ||||||||
| 27.4 | 46.1 | 1 | Standard Error | 1.3741762658 | ||||||||
| 13.8 | 17 | 1 | Observations | 20 | ||||||||
| 11 | 29.2 | 0 | ||||||||||
| 22.4 | 30.7 | 1 | ANOVA | |||||||||
| 30.3 | 59.8 | 0 | df | SS | MS | F | Significance F | |||||
| 28.5 | 48 | 1 | Regression | 2 | 623.4158730405 | 311.7079365202 | 165.0680320194 | 0 | ||||
| 26.7 | 55.3 | 0 | Residual | 17 | 32.1021269595 | 1.8883604094 | ||||||
| 21.9 | 42.9 | 0 | Total | 19 | 655.518 | |||||||
| 22.1 | 47.2 | 0 | ||||||||||
| 18.7 | 40.1 | 0 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | ||||
| 21.8 | 36.5 | 1 | Intercept | 0.0074901501 | 1.278688379 | 0.0058576821 | 0.9953944636 | -2.6903065111 | 2.7052868112 | |||
| 11.8 | 20 | 0 | Experience X1 (Months) | 0.4851831671 | 0.0293313135 | 16.5414742251 | 0 | 0.4232995048 | 0.5470668293 | |||
| 14.1 | 30.7 | 0 | Education (College Degree = 1, No College Degree = 0) | 5.5321443541 | 0.6170193011 | 8.9659178315 | 0.0000000748 | 4.2303474208 | 6.8339412874 | |||
| 23.1 | 36.8 | 1 | ||||||||||
| 30.8 | 49.9 | 1 | ||||||||||
| 24.946961187 |
