Question

In: Statistics and Probability

18-E3. Results of multiple regression for expend Summary measures Adj R-Square 71.5% Model Error 4.877 Regression...

18-E3.

Results of multiple regression for expend

Summary measures

Adj R-Square

71.5%

Model Error

4.877

Regression coefficients

Coefficient

Std Err

t-value

P-value

Constant

-7.53

4.27

-1.76

0.08

Age

3.786

0.260

14.56

0.000

Age 2

-0.041

0.004

-10.72

0.000

  1. What is the formula relating salary to age? What would be the predicted salary of someone of age 30?
  2. According to this model, what age is associated with the highest salary?
  3. How well can you predict salary from someone’s age alone?
  4. If these data were used in an age discrimination case, then how might one explain the apparent association with age and claim that there is, in fact, no age discrimination?

Solutions

Expert Solution

a) The regression equation is:
Salary = -7.53 + 3.786*Age - 0.041*(Age)^2

Predicted Salary (Age = 30) = -7.53 + 3.786*30 - 0.041*30*30
Pred. Salary = 69.15

b) Age associated with highest salary:
Differentiating Salary wrt Age,
dS/dA = 3.786 - 2*0.041*age
Age = 3.786/0.082 = 46.17

Double differentiation is negative, hence it is a maxima
Therefore, the age associated with highest salary is 46

c) The model explains 71.5% variation in the salary. Hence, the model is pretty good in predicting salary from someone's age alone.

d) If this data was used in an age discrimination case, the arguments one could provide are that the model is not an exact fit for predicting salary by age. Hence, we cannot say that age predicts an individual's salary at all times. There are exceptions when an individual has higher than expected salary irrespective of their age. Therefore, there is no age discrimination of salary, this purely depends on the individual


Related Solutions

SUMMARY OUTPUT Regression Statistics Multiple R 0.727076179 R Square 0.528639771 Adjusted R Square 0.525504337 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.727076179 R Square 0.528639771 Adjusted R Square 0.525504337 Standard Error 3.573206748 Observations 455 ANOVA df SS MS F Significance F Regression 3 6458.025113 2152.67504 168.601791 2.7119E-73 Residual 451 5758.280717 12.7678065 Total 454 12216.30583 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 99.0% Upper 99.0% Intercept -0.250148858 0.359211364 -0.6963835 0.48654745 -0.9560846 0.45578693 -1.1793476 0.67904987 RBUK 0.025079378 0.023812698 1.05319345 0.29281626 -0.0217182 0.07187699 -0.0365187 0.08667745 RSUS 0.713727515 0.042328316 16.8617037 8.0578E-50 0.6305423 0.79691273 0.60423372 0.82322131...
SUMMARY OUTPUT Regression Statistics Multiple R 0.72707618 R Square 0.52863977 Adjusted R Square 0.52550434 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.72707618 R Square 0.52863977 Adjusted R Square 0.52550434 Standard Error 3.57320675 Observations 455 ANOVA df SS MS F Significance F Regression 3 6458.02511 2152.67504 168.601791 2.7119E-73 Residual 451 5758.28072 12.7678065 Total 454 12216.3058 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 99.0% Upper 99.0% Intercept -0.2501489 0.35921136 -0.6963835 0.48654745 -0.9560846 0.45578693 -1.1793476 0.67904987 RUK 0.02507938 0.0238127 1.05319345 0.29281626 -0.0217182 0.07187699 -0.0365187 0.08667745 RSUS 0.71372752 0.04232832 16.8617037 8.0578E-50 0.6305423 0.79691273 0.60423372 0.82322131...
SUMMARY OUTPUT Regression Statistics Multiple R 0.195389 R Square 0.038177 Adjusted R Square 0.037333 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.195389 R Square 0.038177 Adjusted R Square 0.037333 Standard Error 13.69067 Observations 1142 ANOVA df SS MS F Significance F Regression 1 8481.255 8481.255 45.2492 2.74E-11 Residual 1140 213675.2 187.4344 Total 1141 222156.4 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 40.19631 0.596741 67.35967 0 39.02547 41.36714 39.02547 41.36714 X Variable 1 7.31E-05 1.09E-05 6.726752 2.74E-11 5.18E-05 9.45E-05 5.18E-05 9.45E-05 Discuss the statistical significance of the model...
SUMMARY OUTPUT Regression Statistics Multiple R 0.396235 R Square 0.157002 Adjusted R Square 0.156262 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.396235 R Square 0.157002 Adjusted R Square 0.156262 Standard Error 18.42647 Observations 1142 ANOVA df SS MS F Significance F Regression 1 72088.71 72088.71 212.3161 3.12E-44 Residual 1140 387069.6 339.5348 Total 1141 459158.4 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 26.35917 0.803163 32.8192 7.4E-167 24.78333 27.93501 24.78333 27.93501 X Variable 1 0.000213 1.46E-05 14.57107 3.12E-44 0.000184 0.000242 0.000184 0.000242 a. Write the reqression equation. Discuss the...
SUMMARY OUTPUT Regression Statistics Multiple R 0.195389 R Square 0.038177 Adjusted R Square 0.037333 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.195389 R Square 0.038177 Adjusted R Square 0.037333 Standard Error 36578.71 Observations 1142 ANOVA df SS MS F Significance F Regression 1 6.05E+10 6.05E+10 45.2492 2.74E-11 Residual 1140 1.53E+12 1.34E+09 Total 1141 1.59E+12 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 17779.38 3518.846 5.052617 5.07E-07 10875.24 24683.53 10875.24 24683.53 X Variable 1 522.0407 77.60665 6.726752 2.74E-11 369.7728 674.3086 369.7728 674.3086 Income using age Write the regression equation....
Interpret the tables below Model Summary Model R R Square Adjusted R Square Std. Error of...
Interpret the tables below Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate 1 .454a .206 .206 2.556 a. Predictors: (Constant), Trust in Government Index (higher scores=more trust), Handling of Economy Index (higher scores=higher satisfaction) ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 58566.582 2 29283.291 4481.186 .000b Residual 225395.511 34492 6.535 Total 283962.093 34494 a. Dependent Variable: Q46a. Level of democracy: today b. Predictors: (Constant), Trust in Government Index (higher...
Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate 1 .941a...
Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate 1 .941a .885 .872 1.00528 a. Predictors: (Constant), SelfControl, NumStrains ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 132.570 2 66.285 65.590 .000b Residual 17.180 17 1.011 Total 149.750 19 a. Dependent Variable: AgeFirstArrest b. Predictors: (Constant), SelfControl, NumStrains Coefficientsa Model Unstandardized Coefficients Standardized Coefficients t Sig. 95.0% Confidence Interval for B Collinearity Statistics B Std. Error Beta Lower Bound Upper Bound...
The following is the estimation results for a multiple linear regression model: SUMMARY OUTPUT             Regression...
The following is the estimation results for a multiple linear regression model: SUMMARY OUTPUT             Regression Statistics R-Square                                                       0.558 Regression Standard Error (S)                  863.100 Observations                                               35                                Coeff        StdError          t-Stat    Intercept               1283.000    352.000           3.65    X1                             25.228        8.631                       X2                               0.861        0.372           Questions: Interpret each coefficient.
The following is the estimation results for a multiple linear regression model: SUMMARY OUTPUT             Regression...
The following is the estimation results for a multiple linear regression model: SUMMARY OUTPUT             Regression Statistics R-Square                                                       0.558 Regression Standard Error (S)                  863.100 Observations                                               35                                Coeff        StdError          t-Stat    Intercept               1283.000    352.000           3.65    X1                             25.228        8.631                       X2                               0.861        0.372           Question: 1. A. Write the fitted regression equation. B. Write the estimated intercepts and slopes, associated with their corresponding standard errors. C. Interpret each coefficient.
Using Excel: Regression Statistics Multiple R 0.9021 R- Square 0.8138 Adjusted R Square 0.7828 Standard Error...
Using Excel: Regression Statistics Multiple R 0.9021 R- Square 0.8138 Adjusted R Square 0.7828 Standard Error 9.4006 ANOVA df SS MS F Regression 1 2317.6 2317.6 26.226 Residual 6 530.23 88.372 Total 7 2847.9 Coefficients Standard Error t Stat P-value Intercept 45.897 5.5447 8.2776 0.0002 Number of Surgeries (x) 5.1951 1.0144 5.1211 0.0022 1. r = 0.90 strong positive correlation 2. y = 5.195 x + 45.897 , 3. r2 = 0.8138 , and 4. Se =  9.4006 5. Results of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT