Linear Regression Activity

A random sample of ten professional athletes produced the following data where x is the number of endorsements the player has and y is the amount of money made (in millions of dollars).
 

 

x                      y                                                                                                                                     

0	2
3	8
2	7
1	3
5	13
5	12
4	9
3	9
1	3
4	10
2	5

Use Excel to answer the questions below where appropriate.

 

1. Draw a scatter plot of the data.

2. Use regression to find the equation for the line of best fit.

3. Draw the line of best fit on the scatter plot.

4. What is the slope of the line of best fit? What does it represent?

5. What is the y-intercept of the line of best fit? What does it represent in the context of this exercise?

6. What does an r value of zero mean in the context of this exercise?