Open the FOL file in Case Study Unit 4 entitledManatee Deaths.Save the file under your name and answer the following questions using Excel.Be prepared to submit the answers in the Submission folder entitledCase Study Unit 4.

1.MAKE scatter plot between Number of Manatee deaths and number of Boats.Be sure to consider which variable is the independent (and therefore x) variable and which is the y variable.(2 points)

Clearly, title your scatter plot and properly label your axis. (2 points)

2.Calculate the Correlation Coefficient between Manatee deaths and number of Boats and round to 4 decimals (2 points).

Interpret the Correlation Coefficient.(2 points)

3.Determine the Line of Best Fit equation. (2 points)

Interpret the slope (m) of the Line of Best Fit (2 points)

Interpret the y-intercept (b) of the Best Fit Line (1 point)

4.Determine what the average number of manatee deaths might be if there are 96 boats on the water. (2 point)

5.Determine the Coefficient of Determination. (no points)

Interpret the Coefficient of Determination (2 points)

6.Determine the Standard Error of Estimate (1 points)

Interpret the Standard Error of the Estimate (2 points)

Make sure that all of these calculations are clearly showing on your Excel sheet, save under in a file labelled with your full name and submit to the Submission Folder titledCase Study Unit 4.

BELOW IS THE EXCEL SHEET AS I CANT ATTACH

YEAR - 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014

DEATHS 53 38 35 49 42 60 54 67 82 78 81 95 73 69 79 92 73 90 97 83 88 81 73 68

BOATS 68 68 67 70 71 73 76 81 83 84 90 92 94 95 97 99 99 97 95 90 90 87 90 90

POP 13.3 13.5 13.7 14 14.3 14.6 14.9 15.2 15.6 16 16.3 16.6 17 17.4 17.8 18.2 18.4 18.6 18.7 18.8 18.9 19.1 19.3 19.5

WATER TEMP 71.9 70.4 70.5 71.7 70.9 69.9 71.2 72.5 71.2 70.6 70.9 71.4 71 70.8 70.7 71.2 71.6 70.6 71.1 69.1 71.6 71.8