In: Chemistry
Below is a set of data collected
at 0.95 atm
for the formation of CO
2
gas produced when calcium
carbonate is reacted with aqueous HCl:
Time (min)
Volume CO
2
(mL)
1
0.2
0
2
0.3
0
3
0.5
0
4
0.7
0
5
0.9
0
6
1
.00
7
1.2
0
8
1.3
0
9
1.5
0
10
1.7
0
11
1.9
0
12
2
.00
13
2.2
0
14
2.4
0
15
2.5
0
16
2.7
0
17
2.9
0
18
3
.00
19
3.2
0
20
3.4
0
Your assignment is as follows:
1. Create a spreadsheet in Excel (or equivalent) that
contains this data and does the following
calculations
automatically:
a. Converts each gas volume measurement to
moles of CO
2
produced
(Use a
PV = nRT to
solve
). Do this twice: one column for 0
| P = 0.95 atm | |||||||
| R = 0.08206 L atm/mol.K | |||||||
| n = PV/RT | |||||||
| m = n*(44.01*1000 mg/mol) | |||||||
| In 3 significant figures. | |||||||
| Time (min) | VCO2 (mL) | VCO2 (L) | nCO2 | nCO2 | mCO2 (mg) | nCO2 | nCO2 |
| (T = 273 K) | (T = 298 K) | (T = 298 K) | (T = 273 K) | (T = 298 K) | |||
| 1 | 0.2 | 0.0002 | 8.48124E-06 | 7.76973E-06 | 0.341945736 | 8.48E-06 | 7.77E-06 |
| 2 | 0.3 | 0.0003 | 1.27219E-05 | 1.16546E-05 | 0.512918604 | 1.27E-05 | 1.16E-05 |
| 3 | 0.5 | 0.0005 | 2.12031E-05 | 1.94243E-05 | 0.854864341 | 2.12E-05 | 1.94E-05 |
| 4 | 0.7 | 0.0007 | 2.96843E-05 | 2.7194E-05 | 1.196810077 | 2.97E-05 | 2.72E-05 |
| 5 | 0.9 | 0.0009 | 3.81656E-05 | 3.49638E-05 | 1.538755813 | 3.82E-05 | 3.50E-05 |
| 6 | 1 | 0.001 | 4.24062E-05 | 3.88486E-05 | 1.709728681 | 4.24E-05 | 3.88E-05 |
| 7 | 1.2 | 0.0012 | 5.08875E-05 | 4.66184E-05 | 2.051674417 | 5.09E-05 | 4.66E-05 |
| 8 | 1.3 | 0.0013 | 5.51281E-05 | 5.05032E-05 | 2.222647285 | 5.51E-05 | 5.05E-05 |
| 9 | 1.5 | 0.0015 | 6.36093E-05 | 5.8273E-05 | 2.564593022 | 6.36E-05 | 5.83E-05 |
| 10 | 1.7 | 0.0017 | 7.20906E-05 | 6.60427E-05 | 2.906538758 | 7.21E-05 | 6.60E-05 |
| 11 | 1.9 | 0.0019 | 8.05718E-05 | 7.38124E-05 | 3.248484494 | 8.06E-05 | 7.38E-05 |
| 12 | 2 | 0.002 | 8.48124E-05 | 7.76973E-05 | 3.419457362 | 8.48E-05 | 7.77E-05 |
| 13 | 2.2 | 0.0022 | 9.32937E-05 | 8.5467E-05 | 3.761403098 | 9.33E-05 | 8.55E-05 |
| 14 | 2.4 | 0.0024 | 0.000101775 | 9.32367E-05 | 4.103348835 | 1.02E-04 | 9.32E-05 |
| 15 | 2.5 | 0.0025 | 0.000106016 | 9.71216E-05 | 4.274321703 | 1.06E-04 | 9.71E-05 |
| 16 | 2.7 | 0.0027 | 0.000114497 | 0.000104891 | 4.616267439 | 1.14E-04 | 0.000105 |
| 17 | 2.9 | 0.0029 | 0.000122978 | 0.000112661 | 4.958213175 | 1.23E-04 | 0.000113 |
| 18 | 3 | 0.003 | 0.000127219 | 0.000116546 | 5.129186043 | 1.27E-04 | 0.000116 |
| 19 | 3.2 | 0.0032 | 0.0001357 | 0.000124316 | 5.471131779 | 1.36E-04 | 0.000124 |
| 20 | 3.4 | 0.0034 | 0.000144181 | 0.000132085 | 5.813077516 | 1.44E-04 | 0.000132 |