Submit a printout of the plot of 1/V vs. 1/[S] and report the values of KM and Vmax.2) Open file "exercise2" in Excel. (Give the file a new name [File - SAVE AS], save to DISK,and work from this saved file.)This file contains a series of data from three experiments. In each experiment, the reactionrates (V) were monitored as a function of substrate concentration [S], but in each of the threeexperiments a DIFFERENT ENZYME was used. The concentration of the enzymes was keptfixed, as well as the pH of the solution and the temperature of the reaction. In addition, theV's for each experiment were determined for the same substrate concentration.From the data given, plot Lineweaver-Burke plots for each experiment, determine whichenzyme (X, Y or Z) is catalytically most efficient, and explain why. Submit printouts of theplots you created along with your calculations for KM.3) Auxiliary questions:11What are the units for KM and why does this constant have these units?In the Michaelis-Menten Scheme, what would happen to V (equation 15) if, insteadof making the steady-state approximation, you assumed that the enzyme-substratecomplex (ES) were in equilibrium with E+S? Show what approximation youneed to make in the steady-state result for V to get the equilibrium result for V.wouldBiochemistry* (1)☆(ii)Please help. EXERCISESUse Excel to answer the questions given below.1) In a typical experiment to characterize an enzyme, Kè and Vmax need to be measured. Todo this, first a series of experiments are run, where for a given initial substrate concentration,the rate at which the product is formed is monitored. The rate of product formation ismonitored by measuring the product concentration as a function of time. A plot ofconcentration of product vs. time will be linear at short time (as long as most of the substratemolecules have not reacted) and the slope of the linear fit to the data is the rate of productformation for a given initial substrate concentration. This is the rate of the reaction (V). Theexperiment is repeated for different initial substrate concentrations (keeping the enzymeconcentration fixed) and the rate of product formation at each of these substrate concentrationsdetermined. This series of experiments results in a set of data: reaction rates (V) as a functionof substrate concentration [S]. Using this data a plot of 1/V vs. 1/[S] is constructed - this plotshould be linear as dictated by equation (18), and from the linear fit KM and Vmax aredetermined.10You will use Excel to analyze data from an experiment of the type just described to determinethe KM and Vmax that characterizes the enzyme used. Open the file "exercise1" in Excel. (Givethe file a new name [File - SAVE AS], save to DISK, and work from this saved file.)This file contains the data from five runs (RUN 1 to RUN 5) monitoring the productconcentration as a function of time for different initial substrate concentrations (all carried outwith the same enzyme concentration). Plot each data set as product concentration vs. time. Fitthe data to a straight line and determine the slope. The slope is the rate of the reaction, V, for aparticular value of [S].Note: In the "Add Trendline" dialog box (accessed from the Chart menu), first select "Linear"(for a linear fit to the data) and then click on Options and select the "Display equation onchart" option. This should show the equation of the straight line fit to the data. Double clickon the equation. This will bring up another dialog box. Click on the "Number" option andchoose Scientific and increase the number of decimal places to 3.You should end up with five values of V for each of the five values of [S]. Plot 1/V vs. 1/[S]and determine KM and Vmax from the straight line fit to the data and equation 18.

Question

Submit a printout of the plot of 1/V vs. 1/[S] and report the values of KM and Vmax.2) Open file &#34;exercise2&#34; in Excel. (Give the file a new name [File -> SAVE AS], save to DISK,and work from this saved file.)This file contains a series of data from three experiments. In each experiment, the reactionrates (V) were monitored as a function of substrate concentration [S], but in each of the threeexperiments a DIFFERENT ENZYME was used. The concentration of the enzymes was keptfixed, as well as the pH of the solution and the temperature of the reaction. In addition, theV's for each experiment were determined for the same substrate concentration.From the data given, plot Lineweaver-Burke plots for each experiment, determine whichenzyme (X, Y or Z) is catalytically most efficient, and explain why. Submit printouts of theplots you created along with your calculations for KM.3) Auxiliary questions:11What are the units for KM and why does this constant have these units?In the Michaelis-Menten Scheme, what would happen to V (equation 15) if, insteadof making the steady-state approximation, you assumed that the enzyme-substratecomplex (ES) were in equilibrium with E+S? Show what approximation youneed to make in the steady-state result for V to get the equilibrium result for V.wouldBiochemistry* (1)☆(ii)Please help. EXERCISESUse Excel to answer the questions given below.1) In a typical experiment to characterize an enzyme, Kè and Vmax need to be measured. Todo this, first a series of experiments are run, where for a given initial substrate concentration,the rate at which the product is formed is monitored. The rate of product formation ismonitored by measuring the product concentration as a function of time. A plot ofconcentration of product vs. time will be linear at short time (as long as most of the substratemolecules have not reacted) and the slope of the linear fit to the data is the rate of productformation for a given initial substrate concentration. This is the rate of the reaction (V). Theexperiment is repeated for different initial substrate concentrations (keeping the enzymeconcentration fixed) and the rate of product formation at each of these substrate concentrationsdetermined. This series of experiments results in a set of data: reaction rates (V) as a functionof substrate concentration [S]. Using this data a plot of 1/V vs. 1/[S] is constructed - this plotshould be linear as dictated by equation (18), and from the linear fit KM and Vmax aredetermined.10You will use Excel to analyze data from an experiment of the type just described to determinethe KM and Vmax that characterizes the enzyme used. Open the file &#34;exercise1&#34; in Excel. (Givethe file a new name [File -> SAVE AS], save to DISK, and work from this saved file.)This file contains the data from five runs (RUN 1 to RUN 5) monitoring the productconcentration as a function of time for different initial substrate concentrations (all carried outwith the same enzyme concentration). Plot each data set as product concentration vs. time. Fitthe data to a straight line and determine the slope. The slope is the rate of the reaction, V, for aparticular value of [S].Note: In the &#34;Add Trendline&#34; dialog box (accessed from the Chart menu), first select &#34;Linear&#34;(for a linear fit to the data) and then click on Options and select the &#34;Display equation onchart&#34; option. This should show the equation of the straight line fit to the data. Double clickon the equation. This will bring up another dialog box. Click on the &#34;Number&#34; option andchoose Scientific and increase the number of decimal places to 3.You should end up with five values of V for each of the five values of [S]. Plot 1/V vs. 1/[S]and determine KM and Vmax from the straight line fit to the data and equation 18.

Accepted Answer

The general equation for initial velocity (V) of a reaction involving a single substrate on an…