Using a spreadsheet to fit experimental pH titration data to a theoretical expression: Estimation of analyte concentration and Ka

Journal of Chemical Education

Volumn 83, Issue 8, 2006, Pages 1190-1193

  Burnett, John ^a   Burns, William A ^a  

^a ARKANSAS STATE UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ACIDS; EDUCATION; PH; SPREADSHEETS; TITRATION; VISUALIZATION;

ACID-BASE; ALPHA FRACTIONS; ANALYTE CONCENTRATION; DIRECT FITTING;

PHYSICAL CHEMISTRY;

EID: 33746987517     PISSN: 00219584     EISSN: None     Source Type: Journal    
DOI: 10.1021/ed083p1190     Document Type: Article

References (36)

1. Breneman, G. L. J. Chem. Educ. 1974, 51, 812.
2. Knudson, G. E.; Nimrod, D. J. Chem. Educ. 1977, 54, 351.
3. Still, E.; Sara, R. J. Chem. Educ. 1977, 54, 348.
4. Stairs, R. A. J. Chem. Educ. 1978, 55, 99.
5. Willis, C. J. J. Chem. Educ. 1981, 58, 659.
6. Currie, J. O., Jr.; Whiteley, R. V., Jr. J. Chem. Educ. 1991, 68, 923.
7. Breneman, G. L.; Parker, O. J. J. Chem. Educ. 1992, 69, 46.
8. (a) de Levie, R. J. Chem. Educ. 1993, 70, 209.
9. (b) de Levie, R. J. Chem. Educ. 1999, 76 987.
10. (a) Glaister, P. J. Chem. Educ. 1997, 74, 744.
11. (b) Glaister, P. J. Chem. Educ. 1999, 76, 132.
12. Papadopoulos, N.; Limniou, M. J. Chem. Educ. 2003, 80, 709.
13. Anfält, T.; Jagner, D. Anal. Chim. Acta 1971, 57, 165.
14. Isbell, A. F., Jr.; Pecsok, R. L.; Davies, R. H.; Purnell, H. J. Anal. Chem. 1973, 45, 2363.
15. Ingman, F.; Johansson, A.; Johansson, S.; Karlsson, R. Anal. Chim. Acta 1973, 64, 113.
16. (a) Barry, D. M.; Meites, L. Anal. Chim. Acta 1974, 68, 435.
17. (b) Barry, D. M.; Meites, L.; Campbell, B. H. Anal. Chim. Acta 1974, 69, 143.
18. Briggs, T. N.; Stuehr, J. E. Anal. Chem. 1974, 46, 1517.
19. Meites, L.; Sluehr, J. E.; Briggs, T. N. Anal. Chem. 1975, 47, 1485.
20. Goode, S. R. Anal. Chem. 1977, 49, 1408.
21. Murtlow, D.; Meites, L. Anal. Chim. Acta 1977, 92, 285.
22. Schwartz, L. M.; Gelb, R. I. Anal. Chem. 1978, 50, 1571.
23. Nowogrocki, G.; Canonne, J.; Wozinak, M. Anal. Chim. Acta 1979, 112, 185.
24. Kateman, G.; Smit, H. C.; Meites, L. Anal. Chim. Acta 1983, 152, 61.
25. Smit, H. C.; Meites, L.; Kateman, G. Anal. Chim. Acta 1983, 153, 121.
26. Ma, N. L.; Tsang, C. W. J. Chem. Educ. 1998, 75, 122.
27. Eaker, C. W. Chem. Educator 2000, 5, 329.
28. Kraft, A. J. Chem. Educ. 2003, 80, 554.
29. Harris, D. C. Quantitative Chemical Analysis, 6th ed; W. H. Freeman: New York, NY, 2003; Chapters 9 and 12.
30. Solver Software Home Page. http://www.solver.com (accessed Apr 2006).
31. Harris, D. C. J. Chem. Educ. 1998, 75, 119.
32. Clark, R. W. Chem. Educator 2000, 4, 112.
33. Billo, E. J. Excel for Chemists: A Comprehensive Guide, 2nd ed; Wiley-VCH: New York, NY, 2001; Chapter 12.
34. (a) de Levie, R. How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis; Cambridge University Press: Cambridge, 2001.
35. (b) de Levie, R. J. Chem. Educ. 1999, 76, 1594.
36. Garland, C. W.; Nibler, J. W.; Shoemaker, D. P. Experiments in Physical Chemistry, 7th ed; McGraw Hill: New York, NY, 2003.