Look at the following data tables obtained by students who performed the experiment in the past...

70.2K

Verified Solution

Question

Biology

Look at the following data tables obtained by students whoperformed the experiment in the past and complete the followingtasks:
Using table 1 as your data set, build yourStandard Curve by plotting protein concentration in the x-axis andabsorbance in the y-axis. Also ask Excel to include the datatrendline, the R2 value and the equation for the linear regression.Donâ€™t forget to label your axis.
Using the data provided by table 2 and the equation obtainedfrom your standard curve, please calculate protein concentration inthe undiluted Mitochondria and Wheat germ extracts.Hint: You can only work with absorbance valuesthat â€œfitâ€ within your standard curve. Hint 2:Remember to multiply by dilution factor if necessary.
Table 1. StandardCurve
Tube N
Protein (Âµg/tube)
A595
Blank
0
0.001
1
10
0.061
2
20
0.149
3
30
0.155
4
40
0.217
5
50
0.236
Table 2. Absorbance ofdifferent samples
ABS
Mitochondria extract
Pure extract
0.217
1/10 dilution
0
1/100 dilution
0
1/1000 dilution
0
Wheat Germ extract
Pure extract
2.26
1/10 dilution
0.365
1/100 dilution
0.159
1/1000 dilution
0

Answer & Explanation Solved by verified expert

4.0 Ratings (729 Votes)

Plot the below data point on excel sheet by selecting ascattered plot and then add trendline to get equation for linearregression and R2 value and then See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Tube N	Protein (Âµg/tube)	A595
Blank	0	0.001
1	10	0.061
2	20	0.149
3	30	0.155
4	40	0.217
5	50	0.236

		ABS
Mitochondria extract	Pure extract	0.217
	1/10 dilution	0
	1/100 dilution	0
	1/1000 dilution	0

Wheat Germ extract	Pure extract	2.26
	1/10 dilution	0.365
	1/100 dilution	0.159
	1/1000 dilution	0