Question

Researchers conducted a study on how the number of powerboats registration may affect the number of manatees killed between year of 1977 and 1990. The data set is contained in the file boat.xlsx. Use Excel to open the data set. The first column is the year, the second column is the number of powerboats registration (in thousand), and the third column is the number of manatees killed.

1) From the research objective, determine which variable is explanatory and which variable is response.

2) Use Excel to sketch a scatter plot and find the correlation coefficient and copy the plot to your work. Do you think this is a strong correlation?

3) Use Excel to find the least square regression line and the coefficient of determination. Make inference on the y-intercept and the slope in the context of the problem.

4) Find the residual for the year of 1984. Show the work.

5) Predict the number of manatees killed if the number of powerboats registration is 600(thousand). Show the work.

year	powerboats	manatees killed
1977	447	13
1978	460	21
1979	481	24
1980	498	16
1981	513	24
1982	512	20
1983	526	15
1984	559	34
1985	585	33
1986	614	33
1987	645	39
1988	675	43
1989	711	50
1990	719	47

Answer 1