In: Chemistry
Using Excel, calculate a titration curve for a weak acid with a
pKa of 3.57 with a
standardized NaOH solution of 0.1138 M. This curve should have a
minimum of 20
calculated points; 15 before equivalence, equivalence, and 4 after
equivalence. It is
STRONGLY recommended that you use the referencing features within
excel to perform
these calculations. They may be done by hand, but will be extremely
tedious! Submit
your (printed) results with an appropriately labeled figure and ALL
calculations shown in
the immediately adjacent cell.
Formal concentration is 0.1000 M
Assume a 25.00 mL aliquot
Please show all work and the formulas you typed into excel
Titration of weak acid with NaOH
NaOH (ml) pH
0 2.236
1 2.246
2 2.565
3 2.761
4 2.906
5 3.025
6 3.125
7 3.218
8 3.299
9 3.374
11 3.570 (half-equivalence point)
12 3.591
14 3.731
16 3.876
22 11.578 (equivalence point)
23 11.588
24 11.674
25 11.839
30 12.220
Plot