Question

A student conducted an experiment to determine what factors are important in the rate of a reaction between potassium carbonate and hydrochloric acid. The student diluted 2.000 mL of 4.000 M K2CO3 to 75.00 mL, then combined that solution with 75.00 mL of 2.000 M HCl.

The student tabulated the amount of CO2 gas collected over time and recorded the results in the columns to the left.

Time (min)	Volume (mL)
1	0.2
2	0.3
3	0.5
4	0.7
5	0.9
6	1
7	1.2
8	1.3
9	1.5
10	1.7
11	1.9
12	2
13	2.2
14	2.4
15	2.5
16	2.7
17	2.9
18	3
19	3.2
20	3.4
21	3.5
22	3.7
23	3.9
24	4.1
25	4.2
26	4.4
27	4.6
28	4.7
29	4.9
30	5.1
31	5.2
32	5.4
33	5.6
34	5.7
35	5.9
36	6.1
37	6.2
38	6.4
39	6.6
40	6.8
41	6.9
42	7.1
43	7.3
44	7.4
45	7.6
46	7.8
47	7.9
48	8.1
49	8.3
50	8.4
51	8.6
52	8.8
53	9
54	9.1
55	9.3
56	9.5
57	9.6
58	9.8
59	10
60	10.1
61	10.3
62	10.5
63	10.6
64	10.8
65	11
66	11.1
67	11.3
68	11.5
69	11.7
70	11.8
71	12
72	12.2
73	12.3
74	12.5
75	12.7
76	12.8
77	13
78	13.2
79	13.3
80	13.5
81	13.7
82	13.8
83	14
84	14.2
85	14.4
86	14.5
87	14.7
88	14.9
89	15
90	15.2
91	15.4
92	15.5
93	15.7
94	15.9
95	16
96	16.2
97	16.4
98	16.6
99	16.7
100	16.9

1. Use a rearrangement of PV = nRT to solve for the number of moles of CO2 produced. You may assume atmospheric pressure and room temperature. Enter (and fill down) your formula in column C.

This is suppose to be an excel file bt i do not know how to manipulate the formula where I can put it into excel and what information to extract from the problem to use in order to help solve the problem.

HELP PLEASE !!

Answer 1

yes it is an excel file

here n = PV/RT , P = 1atm , R= 0.0821 L-atm/k- mol , T = 296 K

1- chnage all the value of Volume into L by dividing 1000

then you will compose excel sheet by below given instructions

1. Use three columns in excel as A,B,C,D

2. Column A will be represent time, column B will represent Vol in ml, Column C vol in L, Column D will repersent no of mole(n)

3. In column D use the formula as fx = (1*C2) / (0.0821*296)

4. Double click the second cell of column D D2, formula will get applied to futher rows of column D.

5. Please refer the excel screenshot.