43. Recall that in exercise 40 the personnel director for Electronics Associates developed the following estimated regression equation relating an employee's score on a job satisfaction test to length of service and wage rate. where = 14.4-8.69x + 13.5x x = = length of service (years) x, wage rate (dollars) y = job satisfaction test score (higher scores indicate greater job satisfaction)

A portion of Excel’s Regression tool output follows.

a. Complete the missing entries in this output.

b. Using α .05, test for overall significance.

c. Did the estimated regression equation provide a good fit to the data? Explain.

d. Use the t test and α .05 to test H0: 1 0 and H0: 2 0.

Transcribed Image Text:

A 1 SUMMARY OUTPUT Regression Statistics 2 3 4 Multiple R 5 R Square 6 Adjusted R Square 7 Standard Error 8 9 Observations 10 ANOVA 11 12 Regression B C D E F G 3.773 df SS MS F Significance F 13 Residual 14 Total 71.17 720 15 16 Coefficients Standard Error 1 Stat P-value 17 Intercept 14.4 8.191 18 XI -8.69 1.555 19 X2 13.517 2.085 20