Question

Is there a way to show how the data was input in excel for this homework,

An experiment is conducted to evaluate the storage conditions for fish after it has been caught. Fish were caught and either directly put into a freezer or left out for different intervals t_lag (3, 6, 9, and 12 hours) before being put into the freezer. The bacterial contamination was evaluated after 7 days of storage in the freezer. For every time point, 3 fish were caught and stored accordingly.

Plot and calculate the linear regression model for the relationship between time interval between catching and freezing fish (t_lag) and the units of bacterial growth (note: you can use Microsoft Excel® or any other program that is able to calculate simple linear regression models.

Answer 1

Answer to this question)
There are two variables in this scenario

Time at which the fish wash put in freezer and bacterial count

Hence column first must contain the time data as x variable

and second column must contain the bacterial count data as y variable.

For time data the values must be entered as follows:

0 for directly put in freezer

3 for hours , 6 hours , 9 hours and 12 hours

For each time observation 3 fish would be selected and their bacterial count would be noted down

This is how the data can be entered in excel

Tlag( x)Bacterial count (y) 1 0 0 0 4 6 6 6 6 1) 10 12 13 14 15 16 17 18 12 12 12