Integrated Rate Law

Question

Time (Seconds)	{PHT}	Ln{PHT}	1/{PHT}
0	0.005000	-5.298	200.0
10.5	0.004500	-5.404	222.22
22.3	00.4000	-5.521	250
35.7	0.003500	-5.655	285.7
51.1	0.00300	-5.809	333.3
69.3	0.002500	-5.991	400
91.6	0.002000	-6.215	500
120.4	0.001500	-6.502	666.7
160.9	0.001000	-6.908	1000
230.3	0.0005000	-7.601	2.000E3

I completed the table and got it correct, however, my problem is setting up the equations to find the slope and correlation.

The second part of this question is using your results from Question 1 (as it appears in your calculator), plot your data:

Enter the absolute value of both slope and correlation into the table below.

Order	slope	correlation
0
1
2

Answer 1

Using an application like Excel or on a graphing calculator plot time on the x axis and on the y axis (1) [PHT], then (2) ln([PHT]), and finally (3) 1/[PHT]. In each case do linear regression and get the equation as well as the R^2 value. In the equation of the form y = mx + b, m is the slope. R^2 is the correlation. Enter both of them in the 2nd table. The correct order of the reaction is the one for which R^2 is close to 1.