R= 0.00199 kcal/mol-deg
%A %B K lnK DG  DG  T= 500 K  
        (kcal/mol) (kJ/mol) kcal= 4.184 kJ  
Text Box: Equation Editor Series Format Cell (number) Formulas Relative and Absolute cell references Charts Printing
99.9 0.1 0.001001 -6.90675 6.872221
99 1 0.010101 -4.59512 4.572144
98 2 0.020408 -3.89182 3.872361
97 3 0.030928 -3.4761 3.458718
96 4 0.041667 -3.17805 3.162164
95 5 0.052632 -2.94444 2.929717
94 6 0.06383 -2.75154 2.737778
93 7 0.075269 -2.58669 2.573756
92 8 0.086957 -2.44235 2.430135
Text Box: 1. Calculate DG in kJ/mol 2. Format the Y-axis on the chart to include a minor unit of 0.1 3. Make a chart of DG vs. lnK. Put the X-axis labels and tick marks at the bottom of the chart. Format the title and axis labels in different fonts/colors. Include the equation on the chart.
91 9 0.098901 -2.31363 2.302067
90 10 0.111111 -2.19722 2.186238
89 11 0.123596 -2.09074 2.080287
88 12 0.136364 -1.99243 1.982468
87 13 0.149425 -1.90096 1.891454
86 14 0.162791 -1.81529 1.806214
85 15 0.176471 -1.7346 1.725928
84 16 0.190476 -1.65823 1.649937
83 17 0.204819 -1.58563 1.577699
82 18 0.219512 -1.51635 1.508766
81 19 0.234568 -1.45001 1.44276
80 20 0.25 -1.38629 1.379363
79 21 0.265823 -1.32493 1.318301
78 22 0.282051 -1.26567 1.259338
77 23 0.298701 -1.20831 1.20227
76 24 0.315789 -1.15268 1.146916
75 25 0.333333 -1.09861 1.093119
74 26 0.351351 -1.04597 1.040739
73 27 0.369863 -0.99462 0.989649
72 28 0.388889 -0.94446 0.939739
71 29 0.408451 -0.89538 0.890907
70 30 0.428571 -0.8473 0.843061
69 31 0.449275 -0.80012 0.796119
68 32 0.470588 -0.75377 0.750003
67 33 0.492537 -0.70819 0.704644
66 34 0.515152 -0.66329 0.659978
65 35 0.538462 -0.61904 0.615944
64 36 0.5625 -0.57536 0.572487
63 37 0.587302 -0.53222 0.529556
62 38 0.612903 -0.48955 0.4871
61 39 0.639344 -0.44731 0.445076
60 40 0.666667 -0.40547 0.403438
59 41 0.694915 -0.36397 0.362146
58 42 0.724138 -0.32277 0.32116
57 43 0.754386 -0.28185 0.280442
56 44 0.785714 -0.24116 0.239956
55 45 0.818182 -0.20067 0.199667
54 46 0.851852 -0.16034 0.159541
53 47 0.886792 -0.12014 0.119544
52 48 0.923077 -0.08004 0.079642
51 49 0.960784 -0.04001 0.039805
50 50 1 0 0
49 51 1.040816 0.040005 -0.03981
48 52 1.083333 0.080043 -0.07964
47 53 1.12766 0.120144 -0.11954
46 54 1.173913 0.160343 -0.15954
45 55 1.222222 0.200671 -0.19967
44 56 1.272727 0.241162 -0.23996
43 57 1.325581 0.281851 -0.28044
42 58 1.380952 0.322773 -0.32116
41 59 1.439024 0.363965 -0.36215
40 60 1.5 0.405465 -0.40344
39 61 1.564103 0.447312 -0.44508
38 62 1.631579 0.489548 -0.4871
37 63 1.702703 0.532217 -0.52956
36 64 1.777778 0.575364 -0.57249
35 65 1.857143 0.619039 -0.61594
34 66 1.941176 0.663294 -0.65998
33 67 2.030303 0.708185 -0.70464
32 68 2.125 0.753772 -0.75
31 69 2.225806 0.800119 -0.79612
30 70 2.333333 0.847298 -0.84306
29 71 2.448276 0.895384 -0.89091
28 72 2.571429 0.944462 -0.93974
27 73 2.703704 0.994623 -0.98965
26 74 2.846154 1.045969 -1.04074
25 75 3 1.098612 -1.09312
24 76 3.166667 1.15268 -1.14692
23 77 3.347826 1.208311 -1.20227
22 78 3.545455 1.265666 -1.25934
21 79 3.761905 1.324925 -1.3183
20 80 4 1.386294 -1.37936
19 81 4.263158 1.45001 -1.44276
18 82 4.555556 1.516347 -1.50877
17 83 4.882353 1.585627 -1.5777
16 84 5.25 1.658228 -1.64994
15 85 5.666667 1.734601 -1.72593
14 86 6.142857 1.81529 -1.80621
13 87 6.692308 1.900959 -1.89145
12 88 7.333333 1.99243 -1.98247
11 89 8.090909 2.090741 -2.08029
10 90 9 2.197225 -2.18624
9 91 10.11111 2.313635 -2.30207
8 92 11.5 2.442347 -2.43014
7 93 13.28571 2.586689 -2.57376
6 94 15.66667 2.751535 -2.73778
5 95 19 2.944439 -2.92972
4 96 24 3.178054 -3.16216
3 97 32.33333 3.476099 -3.45872
2 98 49 3.89182 -3.87236
1 99 99 4.59512 -4.57214
0.1 99.9 999 6.906755 -6.87222
0.01 99.99 9999 9.21024 -9.16419