Standard deviation of 1/1 1/S 1/v1 1/V2 1/V3 1/S Average 1/V Substrate (S) Velocity (V) (mmol/s) Concentraion (mmol) Vi V2 V3 0.02 0.0020 0.0019 0.0018 0.04 0.0028 0.0025 0.0026 0.06 0.0034 0.0028 0.0028 0.08 0.0038 0.0036 0.0031 0.1 0.0034 0.0037 0.0038 0.12 0.0034 0.0038 0.0038 0.14 0.0039 0.0036 0.0041 0.16 0.0041 0.0045 0.0034 0.18 0.0042 0.0037 0.0045 0.2 0.0042 0.0036 0.0044 Note: substrate concentration is given in milli mole (mMol) Velocity is measured in mili mole / second Calculate the 1/S and 1/11, 1/V2, 1/v3 using the appropriate Excel command (2 points) Calculate avearge 1/V from the average 1/V1, 1/V2, 1/V3 values using the appropriate command ( 1 point) Calculate the population standard deviation for 1/V using the appropriate command ( 1 point) Plot 1/V vs. 1/S in an XY scatter plot (3 points) Add the standard deviation you calculated from thre 3 readings as the Y error bars, do NOT display Xerror bars (3 point) Add an appropriate title for the chart and axis labels, is no need to display values for 1/v or 1/s. Adjust scales if necessary. Points may be deducted for inapprpriate Add trendline, regression equation and display R? (2 points) ale on graph (2 points) using the regression equation only, calulate the values of Vmax and Km Vmax= Km= (6 points for values of Vmax and km) (Hint, you should be able to figure out what do the slope and the Y intercept means from the double-reciprocal plot equation. I showed you how to do that during our computer lab session, don't ask me how to do this test.. Lol) 1 1 V. Km 1 + Vmax [S] Vma max Standard deviation of 1/1 1/S 1/v1 1/V2 1/V3 1/S Average 1/V Substrate (S) Velocity (V) (mmol/s) Concentraion (mmol) Vi V2 V3 0.02 0.0020 0.0019 0.0018 0.04 0.0028 0.0025 0.0026 0.06 0.0034 0.0028 0.0028 0.08 0.0038 0.0036 0.0031 0.1 0.0034 0.0037 0.0038 0.12 0.0034 0.0038 0.0038 0.14 0.0039 0.0036 0.0041 0.16 0.0041 0.0045 0.0034 0.18 0.0042 0.0037 0.0045 0.2 0.0042 0.0036 0.0044 Note: substrate concentration is given in milli mole (mMol) Velocity is measured in mili mole / second Calculate the 1/S and 1/11, 1/V2, 1/v3 using the appropriate Excel command (2 points) Calculate avearge 1/V from the average 1/V1, 1/V2, 1/V3 values using the appropriate command ( 1 point) Calculate the population standard deviation for 1/V using the appropriate command ( 1 point) Plot 1/V vs. 1/S in an XY scatter plot (3 points) Add the standard deviation you calculated from thre 3 readings as the Y error bars, do NOT display Xerror bars (3 point) Add an appropriate title for the chart and axis labels, is no need to display values for 1/v or 1/s. Adjust scales if necessary. Points may be deducted for inapprpriate Add trendline, regression equation and display R? (2 points) ale on graph (2 points) using the regression equation only, calulate the values of Vmax and Km Vmax= Km= (6 points for values of Vmax and km) (Hint, you should be able to figure out what do the slope and the Y intercept means from the double-reciprocal plot equation. I showed you how to do that during our computer lab session, don't ask me how to do this test.. Lol) 1 1 V. Km 1 + Vmax [S] Vma max