Question

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

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 tlag (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 (tlag) 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.

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
PLEASE LET ME KNOW HOW TO SOLVE THIS IN MICROSOFT EXCEL...EXCEL PLEASE A company wants to...
PLEASE LET ME KNOW HOW TO SOLVE THIS IN MICROSOFT EXCEL...EXCEL PLEASE A company wants to study the relationship between an employee's length of employment and their number of workdays absent. The company wants to be able to estimate the number of workdays absent based on the employee's length of employment. The company collected the following information on a random sample of seven employees. Somewhere in the spreadsheet: 1) Create a Scatter Chart to visually show the relationship between the...
An investment banking firm was considering two spreadsheet software for possible use in its large data...
An investment banking firm was considering two spreadsheet software for possible use in its large data analysis operations. A sample of 20 typical analysis problems were carried out using both software on the firm’s standard personal computer. The time in minutes needed to load the data, program the spreadsheet calculations, carry out the analysis, and print the results was recorded for each problem for each software. The data for software A are stored in column 1 of the Excel data...
An investment banking firm was considering two spreadsheet software for possible use in its large data...
An investment banking firm was considering two spreadsheet software for possible use in its large data analysis operations. A sample of 25 typical analysis problems were carried out using both software on the firm’s standard personal computer. The time in minutes needed to load the data, program the spreadsheet calculations, carry out the analysis, and print the results was recorded for each problem for each software. The data for software A are stored in column 1 of the Excel data...
I. Solve the following problem: For the following data: 1, 1, 2, 2, 3, 3, 3,...
I. Solve the following problem: For the following data: 1, 1, 2, 2, 3, 3, 3, 3, 4, 4, 5, 6 n = 12 b) Calculate 1) the average or average 2) quartile-1 3) quartile-2 or medium 4) quartile-3 5) Draw box diagram (Box & Wisker) II. PROBABILITY 1. Answer the questions using the following contingency table, which collects the results of a study to 400 customers of a store where you want to analyze the payment method. _______B__________BC_____ A...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...