Question: Please use Excel:

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 10 people employed in Nashville provided the following information:

x ( No. of job changes) | 4 7 5 6 1 5 9 10 10 3

y (Salary in $1000) | 33 37 34 32 32 38 43 37 40 33

(a) Draw a scatter diagram for the data

(b) Looking at the scatter diagram and least-squares line, do you think the correlation coefficient will be positive, negative, or zero?

(c) Looking at the scatter diagram and least-squares line, do you think the slope will be positive, negative, or zero?

(d) Find r. Find the coefficient of determination.

(e) Test the claim that the population correlation coefficient is positive (use a 5% level of significance).

(f) Find the sample means for Number of job changes and Salary (in $1000).

(g) Estimate the equation of the least-squares line.

(h) Graph the least-square line on your scatter diagram.

(i) What is the estimated salary for someone with 2 job changes?

(j) Find a 90% confidence interval for the coefficient on number of job changes.

(k) Test the claim that the slope coefficient is positive (use a 5% level of significance).