Question

Can someone show me how to implement the data below in Excel? I want to create a Michaelis-Menten plot and a Lineweaver-Burk plot. Please explain how to insert the data in Excel so that I can create the graphs. Thank you. pH = 8.0 Abs. 410 nm - 50 µM PNP 0.3478 A Time (seconds) Δ Abs. 410 nm (0.0 mM PNPP) Δ Abs. 410 nm (0.01 mM PNPP) Δ Abs. 410 nm (0.025 mM PNPP) Δ Abs. 410 nm (0.05 mM PNPP) Δ Abs. 410 nm (0.1 mM PNPP) Δ Abs. 410 nm (0.15 mM PNPP) 0 (without enzyme) -0.000 -0.010 -0.010 -0.010 -0.010 -0.010 5 -0.010 0.019 0.074 0.070 0.070 0.066 20 -0.010 0.043 0.153 0.174 0.182 0.185 40 -0.010 0.092 0.226 0.271 0.321 0.330 60 -0.010 0.123 0.271 0.345 0.444 0.456 80 -0.010 0.139 0.305 0.418 0.552 0.589 100 -0.010 0.146 0.328 0.477 0.649 0.709 120 -0.010 0.150 0.344 0.529 0.735 0.823 140 -0.010 0.151 0.354 0.570 0.808 0.922 160 -0.010 0.151 0.360 0.599 0.874 1.018 180 -0.010 0.151 0.363 0.623 0.935 1.094

          Can someone show me how to implement the data below in Excel? I want to create a Michaelis-Menten plot and a Lineweaver-Burk plot. Please explain how to insert the data in Excel so that I can create the graphs. Thank you.

pH = 8.0
Abs. 410 nm - 50 µM PNP 
0.3478 A
Time (seconds)
Δ Abs. 410 nm (0.0 mM PNPP)
Δ Abs. 410 nm (0.01 mM PNPP)
Δ Abs. 410 nm (0.025 mM PNPP)
Δ Abs. 410 nm (0.05 mM PNPP)
Δ Abs. 410 nm (0.1 mM PNPP)
Δ Abs. 410 nm (0.15 mM PNPP)
0 (without enzyme)
-0.000
-0.010
-0.010
-0.010
-0.010
-0.010
5
-0.010
0.019
0.074
0.070
0.070
0.066
20
-0.010
0.043
0.153
0.174
0.182
0.185
40
-0.010
0.092
0.226
0.271
0.321
0.330
60
-0.010
0.123
0.271
0.345
0.444
0.456
80
-0.010
0.139
0.305
0.418
0.552
0.589
100
-0.010
0.146
0.328
0.477
0.649
0.709
120
-0.010
0.150
0.344
0.529
0.735
0.823
140
-0.010
0.151
0.354
0.570
0.808
0.922
160
-0.010
0.151
0.360
0.599
0.874
1.018
180
-0.010
0.151
0.363
0.623
0.935
1.094

Added by Manuel C.

Question

Please give Ace some feedback