Spreadsheet Assignment #5 - Evaluation of First-order Kinetics with Different Rate Constants

[Back to Group 1 Assignments] [Back to Chem3020 home]

First-order kinetics follow the equation, A(t) = A(o) * exp(-k*t).  Evalulate this equation for various values of k (0.01, 0.02, 0.05, 0.10, 0.20, 0.50, and 1.00) for times from 1 to 20 (arbitrary units).  Assume A(o) = 1.00.   Create a chart that plots all seven lines with time on the x-axis and A(t) on the y-axis.  After printing the chart with the standard axes, change the y-axis to a log-scale and print a second copy.

	Rate  Constants (k):
Time	0.010	0.020	0.050	0.100	0.200	0.500	1.000
0	1.000	1.000	1.000	1.000	1.000	1.000	1.000
1	0.990	0.980	0.951	0.905	0.819	0.607	0.368
2	0.980	0.961	0.905	0.819	0.670	0.368	0.135
3	0.970	0.942	0.861	0.741	0.549	0.223	0.050
...	...	...	...	...	...	...	...
20	...	...	...	...	...	...	...

Excel Programming Tips:

- Sometimes the chart wizard can figure out the correct points to graph (and sometimes it cannot). It works well with this assignment. After completing the spreadsheet, you can select all 7 data sets. Don’t select the rate constants because they do not represent points on your graph. - Click on the chart wizard button:

- You will be prompted to select chart type. Select scatter and hit next.

- All seven lines should appear on your chart, each with a different color. Chart wizard has selected columns as a probable data arrangement (you can click on rows to see what it would look like). With columns selected click next. You can label your axis and put a title on the chart. Select Finish.

- To change an axis, select the proper axis and right click on it.