In: Statistics and Probability
Use the data shown in the table that shows the number of bacteria present after a certain number of hours. Replace each y-value in the table with its logarithm. log y. Find the equation of the regression line for the transformed data. Then construct a scatterplot of (x, log y) and sketch the regression line with it. What do you notice?
Number of hours, x: 1 2 3 4 5 6 7
Number of bacteria, y: 325 533 965 1623 2777 4867 8373
Find the equation of the regression line of the transformed data
log y = ___ x + ____
Number of hours, x: | Number of bacteria, y: | Log Y |
1 | 325 | 5.783825182 |
2 | 533 | 6.278521424 |
3 | 965 | 6.872128101 |
4 | 1623 | 7.392031568 |
5 | 2777 | 7.929126487 |
6 | 4867 | 8.49023301 |
7 | 8373 | 9.032767522 |
The plot between X and Log y is given below:
The line is a perfect fit, the correlation must be super close to 1.
The equation of the regression line of the transformed data
The model run in excel is :
Please let me know in comments in case anything is unclear. Will reply ASAP. Do upvote if satisfied!