For the following data sets find the equation of the regression line and construct a scatter plot of the data and draw a regression line in the scatterplot. Can you form an estimate about the sign and magnitude of r? Calculate r and check your estimate. Use Microsoft Excel to perform these tests.
a. The number of hours spent playing video games on the weekend and the age (in years) of 8 children).
|
Age
|
8
|
12
|
13
|
11
|
9
|
14
|
13
|
15
|
|
Hours
|
4
|
6
|
6
|
7
|
5
|
8
|
8
|
5
|
b. The average time spent watching television and the average time spent playing sports each day for 8 children. This is measured in minutes.
|
Television
|
35
|
30
|
15
|
60
|
100
|
45
|
40
|
35
|
|
Sports
|
30
|
30
|
45
|
60
|
15
|
30
|
30
|
50
|