Please help with how to do #2 in Excel. #1 is already answered and data is shown in the image. Task 1: Determine the rat

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Please help with how to do #2 in Excel. #1 is already answered and data is shown in the image. Task 1: Determine the rat

Post by answerhappygod »

Please help with how to do #2 in Excel. #1 is already answered
and data is shown in the image.
Task 1: Determine the rate of a wildtype BglB enzyme
catalyzed reaction and convert from absorbance to molarity using
Beer’s Law.
1. Create a correctly formatted figure that shows reaction rate
graphs for the Wildtype BglB reaction you carried out, plotting
absorbance as the dependent variable with time in minutes as the
independent variable. The slope of the linear regression trendline
for each curve is the reaction rate in units of absorbance per
minute for that trial. What reaction rate was obtained at the two
substrate concentrations?
Please Help With How To Do 2 In Excel 1 Is Already Answered And Data Is Shown In The Image Task 1 Determine The Rat 1
Please Help With How To Do 2 In Excel 1 Is Already Answered And Data Is Shown In The Image Task 1 Determine The Rat 1 (117.4 KiB) Viewed 63 times
2. Now convert the rates from absorbance units/minute to values
that are more directly related to the amount of the product of the
reaction (p nitrophenol or PNP) produced per minute. Use Beer’s law
to convert the reaction rates from units of absorbance to units of
molarity. The reaction rates (abs/min) determined in question
2 go into the Beer’s law equation as “A”, the molar absorptivity
(ε) of PNP product is 10,660 M-1 cm1, and the path length (L) for a
single reaction cuvette is 1 cm. Solve for “c”, which is
concentration in units of M. This will probably be a very small
number so convert to mM or µM PNP produced/minute (how many
millimoles in a mole? How many micromoles in a mole?).
A B с D E F G H 1 U 3.5 1 time (min) absorbance (min-1) 2 1 0.481 3 0.822 4 1.185 5 1.56 6 5 1.925 y+0.2928x + 0.3345 R=0.9717 3 2.1 vau WN 2.5 7 2.266 2 8 2.547 Absorbance (min-1) 9 9 1.5 10 2.783 2.902 2.976 ******** 11 10 1 12 ******* 0.5 5 13 14 15 0 0 0 2 4 8 10 12 16 6 Time (min) 17 18 Figure 1: Description 19 20 21
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply