Source: Pfizer (PFE) PFIZER.NS 5,746.25 75.45 1.33% : Pfizer Limited - Yahoo Finance

Homework 5 rubric Criteria Ratings Pts Linear 40 pts 38 pts 35 pts 35 pts 32 pts 25 pts 20 pts 0 pts regression Correct Minor calculation mistakes Everything correct but not Several calculation mistakes Correct graph Regression Graph missing, Missing parameter but complete numbers and including interpretation of but complete numbers and (excel) but not correct but graph not enough 40 pts estimates and graph parameters graph showing work is missing effort graph ANOVA 30 pts 25 pts 23 pts 15 pts 0 pts table Complete and correct table Complete table wrong df Correct and complete table but missing conclusion Poor effort; many mistakes and missing conclusion Missing 30 pts Cl for 20 pts 18 pts 15 pts 10 pts 0 pts slope Full Marks Minor calculation mistake Missing conclusion Poor effort and missing conclusion Missing 20 pts R^2 10 pts 9 pts 7 pts 0 pts Full Marks calculation mistake Missing interpretation Missing 10 pts Total Points: 1001. 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, 2020 to March 16, 2020 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 3.92 1 1X.X 2.56 9X.X 3.72 10X.X 4.21 12X.X 2.95 10X.X 4.74 13X.X 2.84 1 1X.X 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