Question

roup of scientists are studying the effects of a certain drug that is being tested on mice who have a particular virus. Their results are recorded below Number of days since drug administered 5 Number of mice still affected by the virus 219 95 15 20 25 30 2 24 102 10 282 24 Draw a scatter plot to represent this data. 6. 6.2 Does this seem to follow a linear, exponential or parabolic trend? Suggest a reason for why this might be the case. 6.3 Determine the equation of the regression line, and use this to confirm your answer to Question 6.2 6.4 Determine the correlation coefficient, and describe what this tells us about the relationship between the drug being administered and the virus surviving.

Answer 1

The scatter plot of the data can be drawn by excel as, X represents drugs administered and y represents mice affected by the virus Step 1. Enter the data, 219 10 95 4 15 28 20 2 24 25 30 102

Step 2. click on Insert and then scatter plot as shown below, 250 200 150 100 50 10 30 15 20 25 35 From the scatter plot, it can be concluded that it is following a parabolic path and it can also be seen from the correlation coefficient value.

Step 3. Right click on point, add trendline, polynomial and click on display equation on chart, r-squared value. 250 200 150 y -0.9757x-38.859x3884 100 R2 0.9993 50 10 15 20 25 30 35 The regression line equation is, y-0.9757x-38.859s+388.4

The correlation coefficientR' 0.9993 is approximated equal to 1 which shows the regression line equation is correctly describing the relation between drug being admınistered and the virus surviving The x and y follows the parabolic nature.