| | The following sample data contains the number of years of college and the current annual salary for a random sample of heavy equipment salespeople. | Answer the questions with excel formula by using the following numbers "I need to see all formula when I click on the answers" |
| a. | Which variable is the dependent variable? Which is the independent variable? |
| b. | Determine the least squares estimated regression line. |
| c. | Draw the Scatter plot and trendline |
| d. | Test if the relationship between years of college and income is statistically significant at the .05 level of significance. |
| e. | Calculate the coefficient of determination. |
| f. | Calculate the sample correlation coefficient between income and years of college. Interpret the value you obtain. |
| | | | | Annual Income |
| | | | Years of College | (In Thousands) |
| | | | 2 | 20 |
| | | | 2 | 23 |
| | | | 3 | 25 |
| | | | 4 | 26 |
| | | | 3 | 28 |
| | | | 1 | 29 |
| | | | 4 | 27 |
| | | | 3 | 30 |
| | | | 4 | 33 |
| | | | 4 | 35 |
kenyali333
Book2.xlsx
