In: Statistics and Probability
A sociologist is interested in the relation between x = number of job changes and y = annual salary (in thousands of dollars) for people living in the Nashville area. A random sample of 10 people employed in Nashville provided the following information.
| x (number of job changes) | 6 | 3 | 5 | 6 | 1 | 5 | 9 | 10 | 10 | 3 |
| y (Salary in $1000) | 35 | 36 | 37 | 32 | 32 | 38 | 43 | 37 | 40 | 33 |
Σx = 58; Σy = 363; Σx2 = 422; Σy2 = 13,289; Σxy = 2,173
(a) Find x bar, y-bar, b, and the equation of the least-squares line. (Round your answers for x and y to two decimal places. Round your least-squares estimates to three decimal places.)
(b) Draw a scatter diagram for the data. Plot the least-squares line on your scatter diagram.
(c) Find the sample correlation coefficient r and the coefficient of determination. (Round your answers to three decimal places.)
| r = | |
| r2 = |
What percentage of variation in y is explained by the
least-squares model? (Round your answer to one decimal
place.)
%
(d) If someone had x = 9 job changes, what does the
least-squares line predict for y, the annual salary?
(Round your answer to two decimal places.)
Solution: We can use the excel regression data analysis tool to find the answer to the given questions. The excel output is given below:
| SUMMARY OUTPUT | ||||||
| Regression Statistics | ||||||
| Multiple R | 0.690092023 | |||||
| R Square | 0.476227 | |||||
| Adjusted R Square | 0.410755375 | |||||
| Standard Error | 2.70912701 | |||||
| Observations | 10 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 53.38504673 | 53.38504673 | 7.27379228 | 0.027200241 | |
| Residual | 8 | 58.71495327 | 7.339369159 | |||
| Total | 9 | 112.1 | ||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 31.71962617 | 1.902167291 | 16.67551867 | 1.69133E-07 | 27.33322053 | 36.1060318 |
| x (number of job changes) | 0.789719626 | 0.292814436 | 2.6969969 | 0.027200241 | 0.114488327 | 1.464950926 |
(a) Find x bar, y-bar, b, and the equation of the least-squares line. (Round your answers for x and y to two decimal places. Round your least-squares estimates to three decimal places.)
Answer:

The equation of the least-squares line is:

(b) Draw a scatter diagram for the data. Plot the least-squares line on your scatter diagram.

(c) Find the sample correlation coefficient r and the coefficient of determination. (Round your answers to three decimal places.)
| r = | 0.690 |
| r2 = | 0.476 |
What percentage of variation in y is explained by the
least-squares model? (Round your answer to one decimal
place.)
47.6%
(d) If someone had x = 9 job changes, what does the
least-squares line predict for y, the annual salary?
(Round your answer to two decimal places.)
Answer:
