Please use the table I have filled up in pencil to make the two graphs. For the first table ignore...

Question

Please use the table I have filled up in pencil to make the two graphs. For the first table ignore the gas levels when making the graph. Please make well labelled graph with trendines. And answer the three questions in red ink in the first file. Thanks

Microsoft Word - Fermentation Worksheet(1).docx Fermentation Rates using Different Carbohydrate Food Sources Table 1 – Cumulative CO2 volume for different carbohydrates Time (min) Glucose Water Sucrose Maltose Starch Gas level (mL) Cumul. CO2 Volume (mL) Gas level (mL) Cumul. CO2 Volume (mL) Gas level (mL) Cumul. CO2 Volume (mL) Gas level (mL) Cumul. CO2 Volume (mL) Gas level (mL) Cumul. CO2 Volume (mL) 0 0.1 Zero 0 Zero 0.1 Zero 0.2 Zero 0.1 Zero 2 0.7 0 0.7 0.3 0.2 4 2.5 0.1 2.4 0.5 0.2 6 4.7 0.1 3.5 0.9 0.2 8 5.2 0.1 5.0 1.4 0.2 10 6.6 0.1 6.2 2.1 0.2 12 7.6 0.1 7.3 2.4 0.2 Use the data from Table 1 to create Graph 1. Using Excel do a line of best fit for each data set and have the equation for that line show on the graph. Take the slope of each line, “m” in y=mx+b and put it in Table 2. Insert calculations for fermentation rates here: Table 2 – Fermentation Rates for Different Carbohydrates Carbohydrate Type Fermentation Rate (mL CO2/min) Use the data from Table 2 to create Graph 2. Analyzing the Data • Graph the cumulative CO2 volume data with time in minutes. Graph all 5 data sets on Graph 1. (Remember to use TAILS.) • The fermentation rate (in ml CO2 per minute) can be determined by calculating the slope of the line. Use Excel to determine the line of best fit through your data • Calculate the slope of each line to determine fermentation rate for each carbohydrate and distilled water. • Once the fermentation rate for each carbohydrate is determined record the data in Table 2 and make a graph comparing fermentation rate vs carbohydrate type. Fill in the tables above and insert graphs 1 and 2 here: What is your overall hypothesis for the experiment? Does the data support or disprove your hypothesis? If your data doesn’t support your hypothesis, what would be an alternative hypothesis that is supported by the data? Adapted from: Reinking, L.N., Reinking, J.L. and K.G. Miller 1994. Fermentation, respiration and enzyme specificity: A simple experiment with yeast. The American Biology Teacher, 56:164-168. Bonner, J.M. 2010. A study of fermentation by Saccharomyces cerevesiae. Workshop of the Association for Biology Laboratory Education, McDaniel College, Westminster, MD. 2021-03-08 06:34

fermentation-worksheet1-0f0brguf.pdf 2021-03-08-06-34-xcuyqbky.pdf

Shweta · Accepted Answer

Sheet1
				Glucose			Time(min)	Gas level
			Time(min)	Gas level	Cumul. CO2Vol(ml)		0	0.1
			0	0.1	0		2	0.7
			2	0.7	0		4	2.5
			4	2.5	2.4		6	4.7
			6	4.7	4.6		8	5.2
			8	5.2	5.1		10	6.6
			10	6.6	6.5		12	7.6
			12	7.6	7.5
							Slope	0.6607142857
							Intercept	-0.05
				Water 			Time(min)	Gas level
			Time(min)	Gas level	Cumul. CO2Vol(ml)		0	0
			0	0	0		2	0
			2	0	0		4	0.1
			4	0.1	0.1		6	0.1
			6	0.1	0.1		8	0.1
			8	0.1	0.1		10	0.1
			10	0.1	0.1		12	0.1
			12	0.1	0.1
							Slope	0.0089285714
							INTERCEPT	0.0178571429
				Sucrose 
			Time(min)	Gas level	Cumul. CO2Vol(ml)		Time(min)	Gas level
			0	0.1	0		0	0.1
			2	0.7	0.6		2	0.7
			4	2.4	2.3		4	2.4
			6	3.5	3.4		6	3.5
			8	5	4.9		8	5
			10	6.2	6.1		10	6.2
			12	7.3	7.2		12	7.3
							slope	0.6285714286
							intercept	-0.1714285714
				Maltose			Time(min)	Gas level
			Time(min)	Gas level	Cumul. CO2Vol(ml)		0	0.2
			0	0.2	0		2	0.3
			2	0.3	0.1		4	0.5
			4	0.5	0.3		6	0.9
			6	0.9	0.7		8	1.4
			8	1.4	1.2		10	2.1
			10	2.1	1.9		12	2.4
			12	2.4	2.2
							slope	0.1982142857
							intercept	-0.075
				Starch
			Time(min)	Gas level	Cumul. CO2Vol(ml)		Time(min)	Gas level
			0	0.1	0		0	0.1
			2	0.2	0.1		2	0.2
			4	0.2	0.1		4	0.2
			6	0.2	0.1		6	0.2
			8	0.2	0.1		8	0.2
			10	0.2	0.1		10	0.2
			12	0.2	0.1		12	0.2
							slope	0.0053571429
							INTERCEPT	0.1535714286
Fermentation rate
Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	time
cumulative co2 vol (ml)
Fermentation rate
Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	time
cumulative co2 vol (ml)
Fermentation rate
Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	time
cumulative co2 vol (ml)
Fermentation rate
Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	time
cumulative co2 vol (ml)
Fermentation rate
Gas level	0	2	4	6	8	10	12	0.1	0.7	2.5	4.7	5.2	6.6	7.6	Gas level	0	2	4	6	8	10	12	0.

Microsoft Word - Fermentation Worksheet(1).docx Fermentation Rates using Different Carbohydrate Food Sources Table 1 – Cumulative CO2 volume for different carbohydrates Time (min) Glucose Water...

Answer To: Microsoft Word - Fermentation Worksheet(1).docx Fermentation Rates using Different Carbohydrate Food...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment