EXCEL IS ONLY TO BE USED AS A WAY TO ORGANIZE YOUR WORK AND/OR AS A CALCULATOR. BEYOND THE 'SUM' FUNCTION YOU MAY NOT USE THE FUNCTIONS WITHIN EXCEL TO COMPLETE THE ASSIGNMENT.

7. A researcher is studying recent college graduates (graduated 5 years ago) and is interested in the effect that job turnover, measured as the number of full-time jobs they have held since graduation (X) has on their happiness (Y) on a scale from 1 (very happy) to 10 (very unhappy). She calculated the following quantities for a regression equation:

" = 1.75

" = 5.63

= 11.25

x = 11.50

y = 31.88

Use these data to answer the following questions:

Calculate the equation for the regression line. Interpret the b coefficient in the context of this problem.

Find the coefficient of determination and nondetermination. What do they mean?

Predict the happiness of an individual who has held 3 jobs since graduating.