University of Central Oklahoma Kinetics Data Analysis Worksheet

Pleasesubmit your Microsoft Excel file that includes the following six items.

Item 1. A table like this one, where [KI] is constant, and in units of mol/L, while [(NH4)2S2O8] is changing, also in units of mol/L. Calculate your own reaction rates using the class’ times (linked above). Use determinations 1, 2, 3, 4 for it.

Calculate the reaction order in peroxydisulfate ion, the way you would for a lecture homework problem. I can help you if you need it.

Item 2. A table like the one below, but with [KI] changing and [(NH4)2S2O8] is not changing. Use the entire class’ data for table 2 to calculate the reaction rates.

Calculate the reaction order in iodide ion, the way you would for a lecture homework problem. I can help you if you need it.

Item 3. Calculate the rate constant k, using determinations 1 through 8 and the exponents (reaction orders) that you calculated in item 1 and item 2 above.

Show a table like this one, showing your calculated rate constants and the average k for all of those:

Item 4: Using Table 3, and the entire class’ data for determinations 9, 10, 11, 12, calculate the rate constants k for each temperature. Use the exponents (orders) that you calculated in items 1 and 2 above.

Show a table like this:

and another table like this:

Item 5: Using item 4, graph LN(rate constant k) versus 1/Temperature. Add a linear trendline, and show the equation and the R^2.

Show the graph, with equation, R^2, title, and labeled axes (hint: there are no units for LN(anything), and the units for 1/T will be 1/Kelvin.)

Item 6: Report the collision factor and the activation energy like this:

Remember, the slope of your line equation from item 5 is -Ea/R, so you must solve for Ea.

Remember, the y-intercept of your line equation is LN(A), so you must solve for the A.

Item 7: Calculate the catalyzed rate constant kcat using the whole class’ data from determinations 13, 14, 15, 16, and using the same exponents that you found for item 1 and item 2 above.

Show your results and the average kcat on your Excel sheet like this:

Table 1
Determination MEANS (s)
Change
1 (0.084 M)
90.32611111
76
41.38808569
S2O8
2 (0.042 M)
179.5283333
159.5
52.76456278
3 (0.021 M)
291.8727778
313
119.3235071
4 (0.011 M)
531.875
523
143.6477894
Table 2
5 (0.084 M)
81.22222222
80.5
22.24345391
105
Change KI
6 (0.042 M)
159.2222222
156
40.42648456
102
7 (0.021 M)
257.3888889
246.5
48.38587408
223
8 (0.011 M)
368.6666667
365
118.8766043
375
9 ( 0.0 C)
1654.102857
1750
628.8493373
2136
Change Temp 10 ( 20.0 C)
419.9485714
372
129.5333505
374
11 ( 30.0 C )
345.0780952
274
175.8604844
222
12 ( 40.0 C )
159.3504762
150.62
47.20706721
122
Table 4
13 (0.084 M)
29.53444444
27.31649969
Change KI
14 (0.042 M)
63.87833333
102.7999736
with Cu2+
15 (0.021 M)
77.075
126.7815696
16 (0.011 M)
101.5483333
190.7647883
Table 3
MEDIANS (s) ST DEVS (s)
Mark Leslie Alex
Arsheya Aatikah
58
57
101
113
184
190
341
355
1838
1895
841
1750
339
349
501
324
223
228
907
665
121
121
119
125
68
63
120
320
320
380
525
542
Cesar Shadman
3168
446
511
122
110
350
350
478
85
75
77
152
154
157
330
313
313
793
751
615
86
70
81
174
190
185
231
248
245
259
231
226
Lizeth Elizabeth
Audrey Ambar
75
47
61
85
154
196
79
53
58
363
366
414
66
87
80
136
181
132
233
251
245
261
234
229
20
37
34
21
Dhwani Ashley
1020
2100
420
600
300
480
180
240
40
28
20
40
53
45
37
53
47
31
34
47
16
15
21
16
Sophia Carla
52.86
83.64
65.37
155.91
153.78
135.82
327.76
308.75
316.2
637.64
738.18
617.93
1440
1815.22
1818.24
1570.4
540
319.29
352.04
378.75
360
361.57
383.06
408.73
180
124.43
136.82
307.73
28
45
31
15
Yingjing Daria
Dylan Alfred Ivan
2148.52
2190.36
2222.42
1380
810.11
595.25
305.48
369
203.32
255.44
225.52
242
154.98
150.62
152.78
132
0.58
1.07
0.76
18.6
6.83
0.44
0.54
17
0.34
0.46
0.55
12
0.6
13.61
5.66
28
Cecilia Tatevik
164
164
235
284
319
505
458
405
1440
1500
369
372
253
249
180
138
19
22
18.61
19
2
9
19
17
21
23
12
21
30
26
17
28
Hans Bryan
196
303
445
561
15
18
23
30
73
65
91
212
215
232
372
290
321
468
555
514
1085
85
1293
260
320
475
184
274
311
157
215
167
Madisen Destiny
Jeimi and Shione
105
82
82
73
225
168
175
154
381
312
275
278
276
558
481
488
90
85
153
66
184
122
138
136
252
308
235
325
490
234
441
479
74
64
162
182
335
305
567
484
87
62
181
132
255
225
498
446