25 Mar Take the dataset dataset_assignment1.xls? and, using SPSS, run the same regression as we did in class (with health, age, and mo
Take the dataset “dataset_assignment1.xls” and, using SPSS, run the same regression as we did in class (with health, age, and motivation as independent variables). Then compare the results to those shown on the slides (slide # 37).
Copy the relevant tables from the SPSS output into a Word document and explain/discuss your results (and the differences to those produced in class). Submit the document as a One PDF page.
37Quant. Methods 1 (M. Messner)
Hypotheses in OLS regression
Productivity (person i) = ß0 + ß1* Health (i) + ß2 * Age (i) + ß3* Motivation (i) + u(i)
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 87.3750 54.2176 1.612 0.168 Health 0.3699 0.4175 0.886 0.416 Age -0.6697 0.5406 -1.239 0.270 Motivation -0.3754 0.3588 -1.046 0.343
Residual standard error: 9.923 on 5 degrees of freedom Multiple R-squared: 0.4418, Adjusted R-squared: 0.1069 F-statistic: 1.319 on 3 and 5 DF, p-value: 0.366
,
Tabelle1
| Person | Productivity | Health | Age | Motivation |
| 1 | 40 | 80 | 50 | 80 |
| 2 | 50 | 85 | 59 | 90 |
| 3 | 60 | 88 | 46 | 90 |
| 4 | 45 | 76 | 58 | 65 |
| 5 | 70 | 78 | 43 | 65 |
| 6 | 55 | 67 | 59 | 70 |
| 7 | 44 | 60 | 61 | 78 |
| 8 | 36 | 65 | 55 | 80 |
| 9 | 50 | 70 | 44 | 90 |
| 10 | 40 | 80 | 50 | 80 |
| 11 | 50 | 85 | 59 | 90 |
| 12 | 60 | 88 | 46 | 90 |
| 13 | 45 | 76 | 58 | 65 |
| 14 | 70 | 78 | 43 | 65 |
| 15 | 55 | 67 | 59 | 70 |
| 16 | 44 | 60 | 61 | 78 |
| 17 | 36 | 65 | 55 | 80 |
| 18 | 50 | 70 | 44 | 90 |
| 19 | 40 | 80 | 50 | 80 |
| 20 | 50 | 85 | 59 | 90 |
| 21 | 60 | 88 | 46 | 90 |
| 22 | 45 | 76 | 58 | 65 |
| 23 | 70 | 78 | 43 | 65 |
| 24 | 55 | 67 | 59 | 70 |
| 25 | 44 | 60 | 61 | 78 |
| 26 | 36 | 65 | 55 | 80 |
| 27 | 50 | 70 | 44 | 90 |
,
22Quant. Methods 1 (M. Messner)
Regression in SPSS
SPSS:
Enter variable names and then all data points for these variables
Menu: Analyze Regression Linear
Then enter dependent and independent variables
