Excel

OBJETIVE:

The objective of this practice is the determination amount of chloride and iodide present in a given sample by potentiometric titration with a silver indicator electrode.
CALCULATIONS AND RESULTS:
Obtaining volumes endpoint:
We made tables with the data obtained to assess 50mL of the test solution by adding a few drops of HNO3 and 0.5 g of Ba (NO3) 2. Normalized value withAgNO3.



The second assessment obtain:



The third assessment obtain:





The quarter assessment obtain:









Now we do to each ofthe last 3 graphs the potential valuations based on the volume of reagent. Also denote the 1st and 2nd derivative. We also use the method of Great for what we represent also 1 / (Δpot / ΔV). To do this we will make a table with all the data required for each of the ratings.
Rating 2

AgNO3 (ml) | Pot(mV) | V' | pot' | V'' | pot'' | 1/(∆pot/∆V) |
0 | -58 |   |   |   |   | 0 |
0,5 | -58 |0,25 | 0 |   |   | 0 |
1 | -57 | 0,75 | 2 | 0,5 | 4 | 0,375 |
1,5 | -55 | 1,25 | 4 | 1 | 4 | 0,3125 |
2 | -53 | 1,75 | 4 | 1,5 | 0 | 0,4375 |
2,5 | -52 | 2,25 | 2 | 2 | -4 | 1,125 |
3 | -50 | 2,75 | 4 | 2,5 | 4 | 0,6875 |
3,5 | -47 | 3,25 | 6 | 3 | 4 | 0,54166667 |
4 | -45 | 3,75 | 4 | 3,5 | -4 | 0,9375 |
4,5 | -43 | 4,25 | 4 | 4 | 0 | 1,0625 |
5 | -40 | 4,75 | 6 | 4,5 | 4 |0,79166667 |
5,5 | -38 | 5,25 | 4 | 5 | -4 | 1,3125 |
6 | -35 | 5,75 | 6 | 5,5 | 4 | 0,95833333 |
6,5 | -30 | 6,25 | 10 | 6 | 8 | 0,625 |
7 | -26 | 6,75 | 8 | 6,5 | -4 | 0,84375 |
7,5 | -22 | 7,25 | 8 | 7 | 0 | 0,90625 |
8 | -14 | 7,75 | 16 | 7,5 | 16 | 0,484375 |
8,5 | -6 | 8,25 | 16 | 8 | 0 | 0,515625 |
9 | 6 | 8,75 | 24 | 8,5 | 16 | 0,36458333 |
9,1 | 10 | 9,05 | 40 | 8,9 |53,33333 | 0,22625 |
9,2 | 14 | 9,15 | 40 | 9,1 | 0 | 0,22875 |
9,3 | 19 | 9,25 | 50 | 9,2 | 100 | 0,185 |
9,4 | 24 | 9,35 | 50 | 9,3 | 8,88E-12 | 0,187 |
9,5 | 33 | 9,45 | 90 | 9,4 | 400 | 0,105 |
9,6 | 45 | 9,55 | 120 | 9,5 | 300 | 0,07958333 |
9,7 | 65 | 9,65 | 200 | 9,6 | 800 | 0,04825 |
9,8 | 155 | 9,75 | 900 | 9,7 | 7000 | 0,01083333 |
9,9 | 170 | 9,85 | 150 | 9,8 | -7500 |0,06566667 |
10 | 219 | 9,95 | 490 | 9,9 | 3400 | 0,02030612 |
10,1 | 240 | 10,05 | 210 | 10 | -2800 | 0,04785714 |
10,2 | 249 | 10,15 | 90 | 10,1 | -1200 | 0,11277778 |
10,3 | 259 | 10,25 | 100 | 10,2 | 100 | 0,1025 |
10,4 | 263 | 10,35 | 40 | 10,3 | -600 | 0,25875 |
10,5 | 265 | 10,45 | 20 | 10,4 | -200 | 0,5225 |
10,6 | 268 | 10,55 | 30 | 10,5 | 100 | 0,35166667 |
10,7 | 270 | 10,65 |20 | 10,6 | -100 | 0,5325 |
10,8 | 272 | 10,75 | 20 | 10,7 | -3,6E-12 | 0,5375 |
10,9 | 274 | 10,85 | 20 | 10,8 | 3,55E-12 | 0,5425 |
11 | 276 | 10,95 | 20 | 10,9 | 0 | 0,5475 |
11,5 | 285 | 11,25 | 18 | 11,1 | -6,66667 | 0,625 |
12 | 288 | 11,75 | 6 | 11,5 | -24 | 1,95833333 |
12,5 | 290 | 12,25 | 4 | 12 | -4 | 3,0625 |
13 | 293 | 12,75 | 6 | 12,5 | 4 | 2,125 |
13,5 | 295 | 13,25| 4 | 13 | -4 | 3,3125 |
14 | 298 | 13,75 | 6 | 13,5 | 4 | 2,29166667 |
14,5 | 301 | 14,25 | 6 | 14 | 0 | 2,375 |
15 | 303 | 14,75 | 4 | 14,5 | -4 | 3,6875 |
15,5 | 308 | 15,25 | 10 | 15 | 12 | 1,525 |
16 | 312 | 15,75 | 8 | 15,5 | -4 | 1,96875 |
16,5 | 318 | 16,25 | 12 | 16 | 8 | 1,35416667 |
17 | 323 | 16,75 | 10 | 16,5 | -4 | 1,675 |
17,5 | 331 | 17,25 | 16 | 17 | 12 | 1,078125|
18 | 346 | 17,75 | 30 | 17,5 | 28 | 0,59166667 |
18,1 | 353 | 18,05 | 70 | 17,9 | 133,3333 | 0,25785714 |
18,2 | 360 | 18,15 | 70 | 18,1 | 2,49E-11 | 0,25928571 |
18,3 | 372 | 18,25 | 120 | 18,2 | 500 | 0,15208333 |
18,4 | 395 | 18,35 | 230 | 18,3 | 1100 | 0,07978261 |
18,5 | 476 | 18,45 | 810 | 18,4 | 5800 | 0,02277778 |
18,6 | 504 | 18,55 | 280 | 18,5 | -5300 | 0,06625 |...