Please Help!b Biostats!

1. You will need your ticker code for stock prices for this question. Use your ticker code to obtain the closing prices for the following time period: March 2, 2021 to March 16, 2021 Ticker: Etsy, Inc Date: Closing Prices: 03/02/2021 238.43 03/03/2021 208.61 03/04/2021 198.10 3/05/2021 200.30 03/08/2021 190.26 03/09/2021 206.79 03/10/2021 205.93 03/11/2021 220.84 03/12/2021 221.14 03/15/2021 223.23 03/16/2021 215.98 Use the last two digits (the decimals) of the closing price and use them to replace the X.Xs in the following table. Notice that in the dataset a decimal point will separate the two digits. Head width (cm) Biting force (grams/centimer?) 4.31 12X.X 124.3 3.92 1 1XX 116.1 2.56 XX 1.0 3.72 10X.X 103.0 4.21 12X.X 122.6 2.95 10XX 107.9 4.74 13X.X 139.3 2.84 1 1XX 118.4 Imagine that you are examining the functional relationship between head width (measured in centimeters) and biting force (measured in grams per square centimeters) in the tegu lizard. a) Conduct a linear regression by hand. You will need to show the slope and the intercept of the best-fit line. Also, construct a scatterplot graph with all data-points and trace the best-fit line (if you want you can do the graph in Excel) b) Conduct a hypothesis test for the significance of the slope of the best fit line (ANOVA table). c) Calculate a 95% confidence interval on the slope. d) Calculate the coefficient of determination (r?) Show your work and explain all results